pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Knauer, Todd C. <tknauer@twa.com>
To: 'pgsql-interfaces@postgresql.org' <pgsql-interfaces@postgresql.org>
Subject: Access2000
Date: Wed, 9 Feb 2000 11:37:39 -0600
Message-ID: <9D546E233EDED21180EC0090273C5BAD0177CCD0@twakcax2.twa.com> (raw )
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
Message-ID: <9D546E233EDED21180EC0090273C5BAD0177CCD0@twakcax2.twa.com>
Permalink: ../9D546E233EDED21180EC0090273C5BAD0177CCD0@twakcax2.twa.com/
Also on: postgresql.org/message-id/9D546E233EDED21180EC0090273C5BAD0177CCD0@twakcax2.twa.com
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-interfaces@postgresql.org
Cc: tknauer@twa.com
Subject: Re: Access2000
In-Reply-To: <9D546E233EDED21180EC0090273C5BAD0177CCD0@twakcax2.twa.com>
References: <9D546E233EDED21180EC0090273C5BAD0177CCD0@twakcax2.twa.com>
* 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