From: | rdear(at)egomaniacs(dot)net (Rick Dearman) |
---|---|
To: | <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | OID insert fails between MS-Access 2000 and Postgresql 6.5.2 |
Date: | 2000-02-17 13:33:27 |
Message-ID: | 001201bf794b$9481b5e0$2837370a@egomaniacs.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
I have downloaded the latest ODBC driver for postgresql ( http://www.insightdist.com/psqlodbc/ ) and the latest Jet Engine patch from Microsoft. I have created the sample table shown in the ODBC FAQ.
+++++++++++++++++++++++++++++++++++++
create type lo (
internallength=4, externallength=10,
input=int4in, output=int4out,
default='', passedbyvalue
);
create table employee (
id integer,
name varchar(30),
picture lo
);
+++++++++++++++++++++++++++++++++++++
However when I attempt to insert a small icon into the OLE object field and save the record Access gives an error "Couldn't open object for writing. Error #1"
I here included is the excerpt from the psqlcomm.log
CONN ERROR: func=SQLGetConnectOption, desc='fOption=30002', errnum=205, errmsg='Unknown connect option (Get)'
------------------------------------------------------------
henv=139198596, conn=138152060, status=0, num_stmts=16
sock=139198612, stmts=139198652, lobj_type=-999
---------------- Socket Info -------------------------------
socket=-1, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=138158388, buffer_out=138162488
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
CONN ERROR: func=SQLSetConnectOption, desc='fOption=30002, vParam=122356332', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=139198596, conn=138152060, status=0, num_stmts=16
sock=139198612, stmts=139198652, lobj_type=-999
---------------- Socket Info -------------------------------
socket=-1, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=138158388, buffer_out=138162488
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
conn=138152060, SQLDriverConnect( in)='DSN=PostgreSQL;UID=test_user;PWD=;DATABASE=test;SERVER=10.55.55.1;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;', fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='10.55.55.1',port='5432',dbase='test',user='test_user',passwd='test_user001'
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=138152060, query=' '
conn=138152060, query='set DateStyle to 'ISO''
conn=138152060, query='set geqo to 'OFF''
conn=138152060, query='set ksqo to 'ON''
conn=138152060, query='select oid from pg_type where typname='lo''
[ fetched 1 rows ]
[ Large Object oid = 22720 ]
conn=138152060, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=test;SERVER=10.55.55.1;PORT=5432;UID=test_user;PWD=test_user001;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=138152060, query='SELECT Config, nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR: msysconf: Table does not exist.'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=138152060, stmt=138166588, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT Config, nValue FROM MSysConf'
stmt_with_params='SELECT Config, nValue FROM MSysConf'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR083C413C'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: msysconf: Table does not exist.'
------------------------------------------------------------
henv=139198596, conn=138152060, status=1, num_stmts=16
sock=139198612, stmts=139198652, lobj_type=22720
---------------- Socket Info -------------------------------
socket=224, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=138158388, buffer_out=138162488
buffer_filled_in=42, buffer_filled_out=0, buffer_read_in=42
conn=138152060, query='SELECT "employee"."id" FROM "employee" '
[ fetched 0 rows ]
ERROR from backend during send_function: 'ERROR: lo_lseek: invalid large obj descriptor (0)
'
STATEMENT ERROR: func=SQLPutData, desc='', errnum=1, errmsg='Couldnt open large object for writing.'
------------------------------------------------------------
hdbc=138152060, stmt=138166588, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=139200792, parameters_allocated=3
statement_type=1, statement='INSERT INTO "employee" ("id","name","picture") VALUES (?,?,?)'
stmt_with_params=''
data_at_exec=0, current_exec_param=2, put_data=1
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name=''
----------------QResult Info -------------------------------
CONN ERROR: func=SQLPutData, desc='', errnum=110, errmsg='ERROR: lo_lseek: invalid large obj descriptor (0)
'
------------------------------------------------------------
henv=139198596, conn=138152060, status=1, num_stmts=16
sock=139198612, stmts=139198652, lobj_type=22720
---------------- Socket Info -------------------------------
socket=224, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=138158388, buffer_out=138162488
buffer_filled_in=53, buffer_filled_out=0, buffer_read_in=53
conn=138152060, SQLDisconnect
From | Date | Subject | |
---|---|---|---|
Next Message | Guido Goldstein | 2000-02-17 17:31:55 | Re: [INTERFACES] link problems when inheriting from libpq++ |
Previous Message | Chris Holman | 2000-02-17 12:21:47 | link problems when inheriting from libpq++ |