OID insert fails between MS-Access 2000 and Postgresql 6.5.2

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

Browse pgsql-interfaces by date

  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++