Access2000 - Mailing list pgsql-interfaces

Has any testing been done with Access2000?  I tried connecting to my
PostgreSQL 6.5 database on a Sun Sparc20 running Debian Linux from an
NT4/SP5 box running Office2000 (from Access2000).  And can make a connection
but that is about it.  It seems to pertain only to Office2000 as I removed
it and installed Office97 on the NT client and everything works well under
Access97.

CONN ERROR: func=SQLGetConnectOption, desc='fOption=30002', errnum=205,
errmsg='Unknown connect option (Get)'           ------------------------------------------------------------
henv=157752904,conn=157759696, status=0, num_stmts=16           sock=157752920, stmts=157752968, lobj_type=-999
 ---------------- Socket Info -------------------------------           socket=-1, reverse=0, errornumber=0,
errormsg='(null)'          buffer_in=157766032, buffer_out=157770136           buffer_filled_in=0, buffer_filled_out=0,
buffer_read_in=0
CONN ERROR: func=SQLSetConnectOption, desc='fOption=30002,
vParam=156703896', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------          henv=157752904, conn=157759696, status=0,
num_stmts=16          sock=157752920, stmts=157752968, lobj_type=-999           ---------------- Socket Info
-------------------------------          socket=-1, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=157766032,buffer_out=157770136           buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
 
conn=157759696, SQLDriverConnect( in)='DSN=PROS;', fDriverCompletion=1
DSN info:
DSN='PROS',server='pengsun.twa.com',port='5432',dbase='pros',user='dbadmin',
passwd='flytwa'
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=0,
bools_as_char=1               extra_systable_prefixes='dd_;', conn_settings=''
conn=157759696, query=' '
conn=157759696, query='set DateStyle to 'ISO''
conn=157759696, query='set geqo to 'OFF''
conn=157759696, query='set ksqo to 'ON''
conn=157759696, query='select oid from pg_type where typname='lo''   [ fetched 0 rows ]
conn=157759696,
SQLDriverConnect(out)='DSN=PROS;DATABASE=pros;SERVER=pengsun.twa.com;PORT=54
32;UID=dbadmin;PWD=flytwa;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLU
MN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=157759696, 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=157759696, stmt=157810752, 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_CUR09680040'                ----------------QResult Info
-------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  msysconf:
Table does not exist.'           ------------------------------------------------------------           henv=157752904,
conn=157759696,status=1, num_stmts=16           sock=157752920, stmts=157752968, lobj_type=-999
----------------Socket Info -------------------------------           socket=524, reverse=0, errornumber=0,
errormsg='(null)'          buffer_in=157766032, buffer_out=157770136           buffer_filled_in=42,
buffer_filled_out=0,buffer_read_in=42
 
conn=157759696, query='select relname, usename, relhasrules from pg_class,
pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and
int4out(usesysid) = int4out(relowner)order by relname'   [ fetched 31 rows ]
conn=157759696, query='select u.usename, c.relname, a.attname,
a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from
pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) =
int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and
(a.attnum > 0) and c.relname like 'wksinv' order by attnum'   [ fetched 6 rows ]
conn=157759696, query='select u.usename, c.relname, a.attname,
a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from
pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) =
int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and
(a.attnum > 0) and c.relname like 'wksinv' order by attnum'   [ fetched 6 rows ]
conn=157759696, query='select c.relname, i.indkey, i.indisunique,
i.indisclustered from pg_index i, pg_class c, pg_class d where c.oid =
i.indexrelid and d.relname = 'wksinv' and d.oid = i.indrelid'   [ fetched 0 rows ]
CONN ERROR: func=SQLGetInfo, desc='', errnum=209, errmsg='Unrecognized key
passed to SQLGetInfo.'           ------------------------------------------------------------           henv=157752904,
conn=157759696,status=1, num_stmts=16           sock=157752920, stmts=157752968, lobj_type=-999
----------------Socket Info -------------------------------           socket=524, reverse=0, errornumber=0,
errormsg='(null)'          buffer_in=157766032, buffer_out=157770136           buffer_filled_in=101,
buffer_filled_out=0,buffer_read_in=100
 
CONN ERROR: func=SQLGetConnectOption, desc='fOption=30002', errnum=205,
errmsg='Unknown connect option (Get)'           ------------------------------------------------------------
henv=157752904,conn=157777896, status=0, num_stmts=16           sock=157753472, stmts=157943120, lobj_type=-999
 ---------------- Socket Info -------------------------------           socket=-1, reverse=0, errornumber=0,
errormsg='(null)'          buffer_in=157784232, buffer_out=157788336           buffer_filled_in=0, buffer_filled_out=0,
buffer_read_in=0
CONN ERROR: func=SQLSetConnectOption, desc='fOption=30002,
vParam=156704848', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------          henv=157752904, conn=157777896, status=0,
num_stmts=16          sock=157753472, stmts=157943120, lobj_type=-999           ---------------- Socket Info
-------------------------------          socket=-1, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=157784232,buffer_out=157788336           buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
 
conn=157777896, SQLDriverConnect( in)='DSN=PROS;UID=dbadmin;PWD=flytwa;',
fDriverCompletion=0
DSN info:
DSN='PROS',server='pengsun.twa.com',port='5432',dbase='pros',user='dbadmin',
passwd='flytwa'
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=0,
bools_as_char=1               extra_systable_prefixes='dd_;', conn_settings=''
conn=157777896, query=' '
conn=157777896, query='set DateStyle to 'ISO''
conn=157777896, query='set geqo to 'OFF''
conn=157777896, query='set ksqo to 'ON''
conn=157777896, query='select oid from pg_type where typname='lo''   [ fetched 0 rows ]
conn=157777896, SQLDriverConnect(out)='(null)'
conn=157777896, 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=157777896, stmt=157944112, 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_CUR096A0930'                ----------------QResult Info
-------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  msysconf:
Table does not exist.'           ------------------------------------------------------------           henv=157752904,
conn=157777896,status=1, num_stmts=16           sock=157753472, stmts=157943120, lobj_type=-999
----------------Socket Info -------------------------------           socket=516, reverse=0, errornumber=0,
errormsg='(null)'          buffer_in=157784232, buffer_out=157788336           buffer_filled_in=42,
buffer_filled_out=0,buffer_read_in=42
 
conn=157777896, query='SELECT wksinv.machname, wksinv.delltag, wksinv.os,
wksinv.username, wksinv.location, wksinv.phone
FROM wksinv
ORDER BY wksinv.machname;
'   [ fetched 53 rows ]
conn=157777896, query='SELECT wksinv.machname, wksinv.delltag, wksinv.os,
wksinv.username, wksinv.location, wksinv.phone
FROM wksinv
ORDER BY wksinv.machname;
'   [ fetched 53 rows ]

Todd C Knauer
AIS - Network Computing Services
Trans World Airlines
One City Ctr., Rm. 17185, 515 N. 6th St
St. Louis, MO 63101
(314) 589-3384