Access2000 - Mailing list pgsql-interfaces
From | Knauer, Todd C. |
---|---|
Subject | Access2000 |
Date | |
Msg-id | 9D546E233EDED21180EC0090273C5BAD0177CCD0@twakcax2.twa.com Whole thread Raw |
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
pgsql-interfaces by date: