From: marten@feki.toppoint.de
Message-Id: <199908290550.WAA01443@feki.toppoint.de>
Subject: ODBC-Interfaces - connection options ? Error !
To: pgsql-interfaces@postgreSQL.org
Date: Sat, 28 Aug 1999 22:50:23 -0700 (MST)
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

 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