MapInfo and PSQLODBC: Unknown connnect option
От | William Furnass |
---|---|
Тема | MapInfo and PSQLODBC: Unknown connnect option |
Дата | |
Msg-id | AANLkTil-f0-x2nXEhk1gxvS-eUlBGu3s8BDtiSwhHSyB@mail.gmail.com обсуждение исходный текст |
Список | pgsql-odbc |
I'm trying to access PostGIS 1.5 / PostgreSQL 8.4.4 databases from MapInfo 10.5 via PSQLODBC 08.04.0200,200912260001 but get the following 'Unknown connect option' errors in my psqlodbc_xxxx.log. Could this be a PSQLODBC or a MapInfo bug? Cheers, Will [0.007]CONN ERROR: func=PGAPI_GetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Get)' [0.009] ------------------------------------------------------------ [0.009] henv=18CB2100, conn=18CB4008, status=0, num_stmts=16 [0.010] sock=18CB6B68, stmts=18CB8C40, lobj_type=-999 [0.010] ---------------- Socket Info ------------------------------- [0.011] socket=-1, reverse=0, errornumber=0, errormsg='(NULL)' [0.011] buffer_in=415984688, buffer_out=415988792 [0.012] buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0 [0.012]CONN ERROR: func=PGAPI_GetConnectOption, desc='fOption=1998', errnum=205, errmsg='Unknown connect option (Get)' [0.014] ------------------------------------------------------------ [0.014] henv=18CB2100, conn=18CB4008, status=0, num_stmts=16 [0.015] sock=18CB6B68, stmts=18CB8C40, lobj_type=-999 [0.015] ---------------- Socket Info ------------------------------- [0.015] socket=-1, reverse=0, errornumber=0, errormsg='(NULL)' [0.016] buffer_in=415984688, buffer_out=415988792 [0.017] buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0 [0.018]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [0.020] ------------------------------------------------------------ [0.020] henv=18CB2100, conn=18CB4008, status=0, num_stmts=16 [0.021] sock=18CB6B68, stmts=18CB8C40, lobj_type=-999 [0.021] ---------------- Socket Info ------------------------------- [0.022] socket=-1, reverse=0, errornumber=0, errormsg='(NULL)' [0.022] buffer_in=415984688, buffer_out=415988792 [0.023] buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0 [0.023]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1998, vParam=1', errnum=205, errmsg='Unknown connect option (Set)' [0.025] ------------------------------------------------------------ [0.025] henv=18CB2100, conn=18CB4008, status=0, num_stmts=16 [0.025] sock=18CB6B68, stmts=18CB8C40, lobj_type=-999 [0.026] ---------------- Socket Info ------------------------------- [0.026] socket=-1, reverse=0, errornumber=0, errormsg='(NULL)' [0.027] buffer_in=415984688, buffer_out=415988792 [0.027] buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0 [0.029]conn=18CB4008, PGAPI_DriverConnect( in)='DSN=PostgreSQL35W2;', fDriverCompletion=1 [0.034]DSN info: DSN='PostgreSQL35W2',server='localhost',port='5432',dbase='int_mod_2',user='postgres',passwd='xxxxx' [0.035] onlyread='0',protocol='7.4',showoid='1',fakeoidindex='0',showsystable='0' [0.036] conn_settings='', conn_encoding='(null)' [0.036] translation_dll='',translation_option='' [0.039]Driver Version='08.04.0200,200912260001' linking 1400 static Multithread library [0.040]Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190 [0.040] disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=0 [0.041] text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64 [0.042] extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='' [0.091] [ PostgreSQL version string = '8.4.4' ] [0.091] [ PostgreSQL version number = '8.4' ] [0.097]conn=18CB4008, query='select oid, typbasetype from pg_type where typname = 'lo'' [0.106] [ fetched 0 rows ] [0.110] [ Large Object oid = -999 ] [0.110] [ Client encoding = 'UTF8' (code = 6) ] [0.115]conn=18CB4008, PGAPI_DriverConnect(out)='DSN=PostgreSQL35W2;DATABASE=int_mod_2;SERVER=localhost;PORT=5432;UID=postgres;PWD=xxxxxxxx;SSLmode=disable;ReadOnly=0;Protocol=7.4-1;FakeOidIndex=0;ShowOidColumn=1;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=0;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=0;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0;XaOpt=1' [0.147]conn=18CB4008, query='SELECT 1 FROM "mapinfo"."mapinfo_mapcatalog"' [0.151]ERROR from backend during send_query: 'SERROR' [0.151]ERROR from backend during send_query: 'C3F000' [0.152]ERROR from backend during send_query: 'Mschema "mapinfo" does not exist' [0.153]ERROR from backend during send_query: 'P15' [0.153]ERROR from backend during send_query: 'F.\src\backend\catalog\namespace.c' [0.154]ERROR from backend during send_query: 'L2124' [0.155]ERROR from backend during send_query: 'RLookupExplicitNamespace' [0.157]STATEMENT ERROR: func=SC_execute, desc='(null)', errnum=7, errmsg='Error while executing the query' [0.159] ------------------------------------------------------------ [0.159] hdbc=18CB4008, stmt=18CB9248, result=18CB9478 [0.159] prepare=2, internal=0 [0.160] bindings=00000000, bindings_allocated=0 [0.160] parameters=00000000, parameters_allocated=0 [0.160] statement_type=0, statement='SELECT 1 FROM "mapinfo"."mapinfo_mapcatalog"' [0.161] stmt_with_params='SELECT 1 FROM "mapinfo"."mapinfo_mapcatalog"' [0.162] data_at_exec=-1, current_exec_param=-1, put_data=0 [0.162] currTuple=-1, current_col=-1, lobj_fd=-1 [0.162] maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 [0.163] cursor_name='SQL_CUR18CB9248' [0.163] ----------------QResult Info ------------------------------- [0.164] fields=18CB9578, backend_tuples=00000000, tupleField=0, conn=00000000 [0.164] fetch_count=0, num_total_rows=0, num_fields=0, cursor='(NULL)' [0.165] message='ERROR: schema "mapinfo" does not exist', command='(NULL)', notice='(NULL)' [0.165] status=7, inTuples=0 [0.166]CONN ERROR: func=SC_execute, desc='(null)', errnum=110, errmsg='ERROR: schema "mapinfo" does not exist' [0.167] ------------------------------------------------------------ [0.167] henv=18CB2100, conn=18CB4008, status=1, num_stmts=16 [0.168] sock=18CB6B68, stmts=18CB8C40, lobj_type=-999 [0.168] ---------------- Socket Info ------------------------------- [0.169] socket=2252, reverse=0, errornumber=0, errormsg='(NULL)' [0.169] buffer_in=415984688, buffer_out=415988792 [0.169] buffer_filled_in=6, buffer_filled_out=0, buffer_read_in=6 [0.189]conn=18CB4008, query='select public.postgis_version()' [0.198] [ fetched 1 rows ]
В списке pgsql-odbc по дате отправления:
Следующее
От: "Jose Torres"Дата:
Сообщение: Concern about psqlodbc driver when migrating to PostgreSql 8.4