pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive help / color / mirror / Atom feed From: rdear@egomaniacs.net
To: pgsql-interfaces@postgresql.org
Subject: OID insert fails between MS-Access 2000 and Postgresql 6.5.2
Date: Thu, 17 Feb 2000 13:33:27 -0000
Message-ID: <001201bf794b$9481b5e0$2837370a@egomaniacs.net> (raw )
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
Message-ID: <001201bf794b$9481b5e0$2837370a@egomaniacs.net>
Permalink: ../001201bf794b$9481b5e0$2837370a@egomaniacs.net/
Also on: postgresql.org/message-id/001201bf794b$9481b5e0$2837370a@egomaniacs.net
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: rdear@egomaniacs.net
Subject: Re: OID insert fails between MS-Access 2000 and Postgresql 6.5.2
In-Reply-To: <001201bf794b$9481b5e0$2837370a@egomaniacs.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox