Unknown Connect Option (Set) - Mailing list pgsql-odbc
From | Chris Gamache |
---|---|
Subject | Unknown Connect Option (Set) |
Date | |
Msg-id | 20021017223522.38642.qmail@web13801.mail.yahoo.com Whole thread Raw |
In response to | Re: PostgreSQL+ (Beta) and Active Server Pages with @TRANSACTION=REQUIRED (Chris Gamache <cgg007@yahoo.com>) |
List | pgsql-odbc |
Still can't find a way to create an ODBC database connection within an MTS Transaction... Been digging deeper: Here's a sample connection from the psqlodbc-100.log. I can provide a sample connection from the debug log, but it is much more detailed and as a result quite a bit longer, and I don't think it contains information that is any more useful than the regular log. --[snip...]-- Global Options: Version='07.02.0001', fetch=100, socket=4096, unknown_sizes=0, m ax_varchar_size=254, max_longvarchar_size=8190 disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=1 text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char= 1 extra_systable_prefixes='dd_', conn_settings='' conn_encoding='O THER' conn=33947712, query=' ' conn=33947712, query='set DateStyle to 'ISO'' conn=33947712, query='set geqo to 'OFF'' conn=33947712, query='set ksqo to 'ON'' conn=33947712, query='BEGIN' conn=33947712, query='declare SQL_CUR01DA0770 cursor for select oid from pg_type where typname='lo'' conn=33947712, query='fetch 100 in SQL_CUR01DA0770' [ fetched 0 rows ] conn=33947712, query='close SQL_CUR01DA0770' conn=33947712, query='COMMIT' conn=33947712, query='BEGIN' conn=33947712, query='declare SQL_CUR01DA0770 cursor for select version()' conn=33947712, query='fetch 100 in SQL_CUR01DA0770' [ fetched 1 rows ] [ PostgreSQL version string = 'PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66' ] [ PostgreSQL version number = '7.2' ] conn=33947712, query='close SQL_CUR01DA0770' conn=33947712, query='COMMIT' conn=33947712, query='select pg_client_encoding()' [ fetched 1 rows ] [ Client encoding = 'SQL_ASCII' (code = 0) ] conn=33947712, PGAPI_DriverConnect(out)='DRIVER={PostgreSQL+ (Beta)};DATABASE=et c;SERVER=10.10.0.1;PORT=5432;UID=user;PWD=pass;ReadOnly=0;Protocol=6.4;F akeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;F etch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;D ebug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=1;TextAsLongVarchar=1;Unknow nsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes =dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0' CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1207, vParam=124387564', errnum=205, errmsg='Unknown connect option (Set)' ------------------------------------------------------------ henv=31068000, conn=33947712, status=1, num_stmts=16 sock=31067936, stmts=31067856, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=1216, reverse=0, errornumber=0, errormsg='(NULL)' buffer_in=34082824, buffer_out=31026544 buffer_filled_in=63, buffer_filled_out=0, buffer_read_in=63 conn=33947712, PGAPI_Disconnect --[\snip...]-- The problem occurs in PGAPI_SetConnectOption ... I've looked at that routine in options.c, and it seems like its receiving an fOption that it doesn't understand: It has the choice of SQL_ASYNC_ENABLE: SQL_BIND_TYPE: SQL_CONCURRENCY: SQL_CURSOR_TYPE: SQL_KEYSET_SIZE: SQL_MAX_LENGTH: SQL_MAX_ROWS: SQL_NOSCAN: SQL_QUERY_TIMEOUT: SQL_RETRIEVE_DATA: SQL_ROWSET_SIZE: SQL_SIMULATE_CURSOR: SQL_USE_BOOKMARKS: SQL_ACCESS_MODE: /* ignored */ SQL_AUTOCOMMIT: SQL_CURRENT_QUALIFIER: /* ignored */ SQL_LOGIN_TIMEOUT: /* ignored */ SQL_PACKET_SIZE: /* ignored */ SQL_QUIET_MODE: /* ignored */ SQL_TXN_ISOLATION: /* ignored */ SQL_ODBC_CURSORS: SQL_OPT_TRACE: SQL_OPT_TRACEFILE: SQL_TRANSLATE_DLL: SQL_TRANSLATE_OPTION: and of course... default: which gives that error... the culprit is fOption = 1207 which is an unknown option... I have no idea what that maps to since its not in the isqlext.h file! So! How can we (safely?) allow that option while connecting without crashing the odbc driver. What is that option? How would we find out? CG __________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com
pgsql-odbc by date: