Wednesday, March 7, 2012

server to Postgres

Hi

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')

OR

SELECT * FROM OPENQUERY(POSTGRES_1,'select * from TestTable')

Error:
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'].http://support.microsoft.com/default.aspx?scid=kb;EN-US;270119 to followup the issue and resolve.|||Hi Satya,

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.

Regards...|||The only option to suspect is about compatible/proper driver from Postgres, have you tried on Postgres website for any information.|||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.|||Try with latest version of MDAC and OLEDB provider.|||Will try...

No comments:

Post a Comment