MapInfo and PSQLODBC: Unknown connnect option

am 28.06.2010 13:41:40 von William Furnass

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=3DPGAPI_GetConnectOption, desc=3D'', errnum=3D205,
errmsg=3D'Unknown connect option (Get)'
[0.009] --------------------------------------------------------=
----
[0.009] henv=3D18CB2100, conn=3D18CB4008, status=3D0, num_stmts=
=3D16
[0.010] sock=3D18CB6B68, stmts=3D18CB8C40, lobj_type=3D-999
[0.010] ---------------- Socket Info ---------------------------=
----
[0.011] socket=3D-1, reverse=3D0, errornumber=3D0, errormsg=3D'(=
NULL)'
[0.011] buffer_in=3D415984688, buffer_out=3D415988792
[0.012] buffer_filled_in=3D0, buffer_filled_out=3D0, buffer_read=
_in=3D0
[0.012]CONN ERROR: func=3DPGAPI_GetConnectOption, desc=3D'fOption=3D1998',
errnum=3D205, errmsg=3D'Unknown connect option (Get)'
[0.014] --------------------------------------------------------=
----
[0.014] henv=3D18CB2100, conn=3D18CB4008, status=3D0, num_stmts=
=3D16
[0.015] sock=3D18CB6B68, stmts=3D18CB8C40, lobj_type=3D-999
[0.015] ---------------- Socket Info ---------------------------=
----
[0.015] socket=3D-1, reverse=3D0, errornumber=3D0, errormsg=3D'(=
NULL)'
[0.016] buffer_in=3D415984688, buffer_out=3D415988792
[0.017] buffer_filled_in=3D0, buffer_filled_out=3D0, buffer_read=
_in=3D0
[0.018]CONN ERROR: func=3DPGAPI_SetConnectOption, desc=3D'', errnum=3D205,
errmsg=3D'Unknown connect option (Set)'
[0.020] --------------------------------------------------------=
----
[0.020] henv=3D18CB2100, conn=3D18CB4008, status=3D0, num_stmts=
=3D16
[0.021] sock=3D18CB6B68, stmts=3D18CB8C40, lobj_type=3D-999
[0.021] ---------------- Socket Info ---------------------------=
----
[0.022] socket=3D-1, reverse=3D0, errornumber=3D0, errormsg=3D'(=
NULL)'
[0.022] buffer_in=3D415984688, buffer_out=3D415988792
[0.023] buffer_filled_in=3D0, buffer_filled_out=3D0, buffer_read=
_in=3D0
[0.023]CONN ERROR: func=3DPGAPI_SetConnectOption, desc=3D'fOption=3D1998,
vParam=3D1', errnum=3D205, errmsg=3D'Unknown connect option (Set)'
[0.025] --------------------------------------------------------=
----
[0.025] henv=3D18CB2100, conn=3D18CB4008, status=3D0, num_stmts=
=3D16
[0.025] sock=3D18CB6B68, stmts=3D18CB8C40, lobj_type=3D-999
[0.026] ---------------- Socket Info ---------------------------=
----
[0.026] socket=3D-1, reverse=3D0, errornumber=3D0, errormsg=3D'(=
NULL)'
[0.027] buffer_in=3D415984688, buffer_out=3D415988792
[0.027] buffer_filled_in=3D0, buffer_filled_out=3D0, buffer_read=
_in=3D0
[0.029]conn=3D18CB4008, PGAPI_DriverConnect( in)=3D'DSN=3DPostgreSQL35W2;',
fDriverCompletion=3D1
[0.034]DSN info:
DSN=3D'PostgreSQL35W2',server=3D'localhost',port=3D'5432',db ase=3D'int_mod_=
2',user=3D'postgres',passwd=3D'xxxxx'
[0.035]
onlyread=3D'0',protocol=3D'7.4',showoid=3D'1',fakeoidindex=3 D'0',showsystab=
le=3D'0'
[0.036] conn_settings=3D'', conn_encoding=3D'(null)'
[0.036] translation_dll=3D'',translation_option=3D''
[0.039]Driver Version=3D'08.04.0200,200912260001' linking 1400 static
Multithread library
[0.040]Global Options: fetch=3D100, socket=3D4096, unknown_sizes=3D0,
max_varchar_size=3D255, max_longvarchar_size=3D8190
[0.040] disable_optimizer=3D0, ksqo=3D1, unique_index=3D1,
use_declarefetch=3D0
[0.041] text_as_longvarchar=3D1,
unknowns_as_longvarchar=3D0, bools_as_char=3D1 NAMEDATALEN=3D64
[0.042] extra_systable_prefixes=3D'dd_;',
conn_settings=3D'' conn_encoding=3D''
[0.091] [ PostgreSQL version string =3D '8.4.4' ]
[0.091] [ PostgreSQL version number =3D '8.4' ]
[0.097]conn=3D18CB4008, query=3D'select oid, typbasetype from pg_type
where typname =3D 'lo''
[0.106] [ fetched 0 rows ]
[0.110] [ Large Object oid =3D -999 ]
[0.110] [ Client encoding =3D 'UTF8' (code =3D 6) ]
[0.115]conn=3D18CB4008,
PGAPI_DriverConnect(out)=3D'DSN=3DPostgreSQL35W2;DATABASE=3D int_mod_2;SERVE=
R=3Dlocalhost;PORT=3D5432;UID=3Dpostgres;PWD=3Dxxxxxxxx;SSLm ode=3Ddisable;R=
eadOnly=3D0;Protocol=3D7.4-1;FakeOidIndex=3D0;ShowOidColumn= 3D1;RowVersioni=
ng=3D0;ShowSystemTables=3D0;ConnSettings=3D;Fetch=3D100;Sock et=3D4096;Unkno=
wnSizes=3D0;MaxVarcharSize=3D255;MaxLongVarcharSize=3D8190;D ebug=3D1;CommLo=
g=3D1;Optimizer=3D0;Ksqo=3D1;UseDeclareFetch=3D0;TextAsLongV archar=3D1;Unkn=
ownsAsLongVarchar=3D0;BoolsAsChar=3D1;Parse=3D0;CancelAsFree Stmt=3D0;ExtraS=
ysTablePrefixes=3Ddd_;;LFConversion=3D0;UpdatableCursors=3D1 ;DisallowPremat=
ure=3D0;TrueIsMinus1=3D0;BI=3D0;ByteaAsLongVarBinary=3D0;Use ServerSidePrepa=
re=3D0;LowerCaseIdentifier=3D0;XaOpt=3D1'
[0.147]conn=3D18CB4008, query=3D'SELECT 1 FROM "mapinfo"."mapinfo_mapcatalo=
g"'
[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 ex=
ist'
[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=3DSC_execute, desc=3D'(null)', errnum=3D7,
errmsg=3D'Error while executing the query'
[0.159]
------------------------------------------------------------
[0.159] hdbc=3D18CB4008, stmt=3D18CB9248, result=3D18CB9478
[0.159] prepare=3D2, internal=3D0
[0.160] bindings=3D00000000, bindings_allocated=3D0
[0.160] parameters=3D00000000, parameters_allocated=3D0
[0.160] statement_type=3D0, statement=3D'SELECT 1 FROM
"mapinfo"."mapinfo_mapcatalog"'
[0.161] stmt_with_params=3D'SELECT 1 FROM
"mapinfo"."mapinfo_mapcatalog"'
[0.162] data_at_exec=3D-1, current_exec_param=3D-1, put_dat=
a=3D0
[0.162] currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1
[0.162] maxRows=3D0, rowset_size=3D1, keyset_size=3D0,
cursor_type=3D0, scroll_concurrency=3D1
[0.163] cursor_name=3D'SQL_CUR18CB9248'
[0.163] ----------------QResult Info
-------------------------------
[0.164] fields=3D18CB9578, backend_tuples=3D00000000,
tupleField=3D0, conn=3D00000000
[0.164] fetch_count=3D0, num_total_rows=3D0, num_fields=3D0,
cursor=3D'(NULL)'
[0.165] message=3D'ERROR: schema "mapinfo" does not
exist', command=3D'(NULL)', notice=3D'(NULL)'
[0.165] status=3D7, inTuples=3D0
[0.166]CONN ERROR: func=3DSC_execute, desc=3D'(null)', errnum=3D110,
errmsg=3D'ERROR: schema "mapinfo" does not exist'
[0.167] --------------------------------------------------------=
----
[0.167] henv=3D18CB2100, conn=3D18CB4008, status=3D1, num_stmts=
=3D16
[0.168] sock=3D18CB6B68, stmts=3D18CB8C40, lobj_type=3D-999
[0.168] ---------------- Socket Info ---------------------------=
----
[0.169] socket=3D2252, reverse=3D0, errornumber=3D0, errormsg=3D=
'(NULL)'
[0.169] buffer_in=3D415984688, buffer_out=3D415988792
[0.169] buffer_filled_in=3D6, buffer_filled_out=3D0, buffer_read=
_in=3D6
[0.189]conn=3D18CB4008, query=3D'select public.postgis_version()'
[0.198] [ fetched 1 rows ]

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc