Skip site navigation (1) Skip section navigation (2)

Access2000

From: "Knauer, Todd C(dot)" <tknauer(at)twa(dot)com>
To: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Access2000
Date: 2000-02-09 17:37:39
Message-ID: 9D546E233EDED21180EC0090273C5BAD0177CCD0@twakcax2.twa.com (view raw or flat)
Thread:
Lists: 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

Next:From: Phillip RhodesDate: 2000-02-09 18:38:24
Subject: RE: [INTERFACES] jdbc question
Previous:From: Phillip RhodesDate: 2000-02-09 15:50:10
Subject: jdbc question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group