MapInfo and PSQLODBC: Unknown connnect option

From: William Furnass <will(at)thearete(dot)co(dot)uk>
To: pgsql-odbc(at)postgresql(dot)org
Subject: MapInfo and PSQLODBC: Unknown connnect option
Date: 2010-06-28 11:41:40
Message-ID: AANLkTil-f0-x2nXEhk1gxvS-eUlBGu3s8BDtiSwhHSyB@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ]

Browse pgsql-odbc by date

  From Date Subject
Next Message Jose Torres 2010-07-02 21:43:31 Concern about psqlodbc driver when migrating to PostgreSql 8.4
Previous Message James Slater 2010-06-21 16:46:06 Re: AsText