[ 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 22: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.

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

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