Access2000

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