[ psqlodbc-Bugs-1000518 ] "Requested conversion is not supported" when trying to query information_schema.tables on SQL

Bugs item #1000518, was opened at 2006-01-04 23:36
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000518&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: saikit lam (taz_devilzz)
Assigned to: Nobody (None)
Summary: "Requested conversion is not supported" when trying to query information_schema.tables on SQL

Initial Comment:
I got this error:

Could not get the current row value of column '[MSDASQL].table_catalog' from the OLE DB provider 'MSDASQL'.
[OLE/DB provider returned message: Requested conversion is not supported.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetData returned 0x80040e1d].

when I am trying to execute the following queries on SQL Query Analyzer:

a)  SELECT * FROM OPENQUERY(my_linked_server,'SELECT * FROM information_schema.tables')
b)  SELECT * FROM OPENQUERY(ufa_selfserve_PGSQL80,'SELECT * FROM pg_catalog.pg_constraint')

my_linked_server is defined as a SQL linked server using Microsoft OLE DB Provider (MSADSQL).

However, the following error result no error:

SELECT * FROM OPENQUERY(ufa_selfserve_PGSQL80,'SELECT * FROM pg_catalog.pg_depend')

I have tried both psqlodbc-08_01_0102 and psqlodbc-8_01_0106 but they behave the same.

Any help is appreciated.

Thanks.

----------------------------------------------------------------------

>Comment By: Ludek Finstrle (luf)
Date: 2006-01-05 20:31

Message:
Please attach mylog output as it's is more useful for bug hunting (it's much larger so feel free to compress it).

----------------------------------------------------------------------

Comment By: saikit lam (taz_devilzz)
Date: 2006-01-05 00:00

Message:
Here is what I got from the psqlodbc_xxx.log file about the
error:

Global Options: Version='08.01.0102', fetch=100, socket=0,
unknown_sizes=254, max_varchar_size=8190, max_longvarchar_size=0
                disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
                text_as_longvarchar=1,
unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
                extra_systable_prefixes='dd_;',
conn_settings='' conn_encoding='OTHER'
conn=81423936, query='select version()'
    [ PostgreSQL version string = 'PostgreSQL 7.4.7 on
i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502
(Red Hat Linux 3.2.3-47)' ]
    [ PostgreSQL version number = '7.4' ]
conn=81423936, query='set DateStyle to 'ISO''
conn=81423936, query='set geqo to 'OFF''
conn=81423936, query='set extra_float_digits to 2'
conn=81423936, query='select oid from pg_type where
typname='lo''
conn=81423936, query='select pg_client_encoding()'
conn=81423936, query='set client_encoding to 'latin9''
conn=81423936,

PGAPI_DriverConnect(out)='DSN=my_dsn;DATABASE=my_db;SERVER=my_server;PORT=5432;SSLMODE=prefer;UID=me;PWD=pwd;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=8192;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=0;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0'
DESCRIPTOR ERROR: func=PGAPI_SetDescField, desc='',
errnum=11, errmsg='bad parameter number'
conn=81423936, query='SELECT * FROM information_schema.tables'
conn=81423936, PGAPI_Disconnect

Global Options: Version='08.01.0102', fetch=100, socket=0,
unknown_sizes=254, max_varchar_size=8190, max_longvarchar_size=0
                disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
                text_as_longvarchar=1,
unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
                extra_systable_prefixes='dd_;',
conn_settings='' conn_encoding='OTHER'
conn=81423936, query='select version()'
    [ PostgreSQL version string = 'PostgreSQL 7.4.7 on
i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502
(Red Hat Linux 3.2.3-47)' ]
    [ PostgreSQL version number = '7.4' ]
conn=81423936, query='set DateStyle to 'ISO''
conn=81423936, query='set geqo to 'OFF''
conn=81423936, query='set extra_float_digits to 2'
conn=81423936, query='select oid from pg_type where
typname='lo''
conn=81423936, query='select pg_client_encoding()'
conn=81423936, query='set client_encoding to 'latin9''
conn=81423936,

PGAPI_DriverConnect(out)='DSN=my_dsn;DATABASE=my_db;SERVER=my_server;PORT=5432;SSLMODE=prefer;UID=me;PWD=pwd;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=8192;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=0;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0'
DESCRIPTOR ERROR: func=PGAPI_SetDescField, desc='',
errnum=11, errmsg='bad parameter number'
conn=81423936, query='SELECT * FROM pg_catalog.pg_constraint'


----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000518&group_id=1000125