From: Marten Feldtmann <marten@phoenix-edv.netzservice.de>
To: pgsql-interfaces@postgresql.org
Subject: Problems with ODBC connect ...
Date: Thu, 26 Aug 1999 14:11:37 +0100
Message-ID: <37C53D09.E2B0F7AD@phoenix-edv.netzservice.de> (raw)
Hello,
I've a problem in the very first state of the odbc-connection from a
NT 4.0, SP4 and my ODBC driver for PostgreSQL and I get the following
output from my ODBC driver:.
My simple question: why !? What is the "unknown connect option" ?
Marten
The log is following:
conn=62136336, SQLDriverConnect( in)='DSN=PITPSQL;', fDriverCompletion=2
DSN info:
DSN='PITPSQL',server='achterndiek',port='5432',dbase='testdb3',user='postgres',passwd='postgres'
readonly='1',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=0, ksqo=0, 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=62136336, query=' '
conn=62136336, query='set DateStyle to 'ISO''
conn=62136336, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=62136336,
SQLDriverConnect(out)='DSN=PITPSQL;DATABASE=testdb3;SERVER=achterndiek;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
CONN ERROR: func=SQLSetConnectOption, desc='fOption=1041,
vParam=1526592', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=62129728, conn=62136336, status=1, num_stmts=16
sock=62129744, stmts=62129792, lobj_type=-999
---------------- Socket Info -------------------------------
socket=2064, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=62142672, buffer_out=62146776
buffer_filled_in=33, buffer_filled_out=0, buffer_read_in=32
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: marten@phoenix-edv.netzservice.de
Subject: Re: Problems with ODBC connect ...
In-Reply-To: <37C53D09.E2B0F7AD@phoenix-edv.netzservice.de>
* 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