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
