Can anyone help me with this.. driving me nuts.
when setting up a linked server to Postgres 7.3.1 (specifics*) I can see the tables in Enterprise Manager but in Query Analyzer i get this error when doing the below queries
SELECT * FROM OPENQUERY(POSTGRES_1,'select * from dbo.TestTable')
SELECT * FROM OPENQUERY(POSTGRES_1,'select * from TestTable')
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'select id,value_char from dbo.Test_Default_1'. The OLE DB provider 'MSDASQL' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='MSDASQL', Query=select id,value_char from dbo.Test_Default_1'].
I have seen this article before and it does not help with this issue as I cannot select data even using the pass through query syntax shown. Is there anyone you know that has any light on this problem. Getting data through the ODBC connection is fine it's just that the OPENQUERY() returns the error.
I have and I downloaded the version of the ODBC which should be compatible with the current version of Postgres which is 7.3.1. It just keeps bugging me that this is possible an issue with OLEDB for ODBC rather than the ODBC Driver itself but I can't pin point it.