MapInfo and PSQLODBC: Unknown connnect option - Mailing list pgsql-odbc

From William Furnass
Subject MapInfo and PSQLODBC: Unknown connnect option
Date
Msg-id AANLkTil-f0-x2nXEhk1gxvS-eUlBGu3s8BDtiSwhHSyB@mail.gmail.com
Whole thread Raw
List 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 by date:

Previous
From: alexandre - aldeia digital
Date:
Subject: Unicode x ANSI speed
Next
From: "Jose Torres"
Date:
Subject: Concern about psqlodbc driver when migrating to PostgreSql 8.4