Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2004
    Posts
    6

    Unanswered: Linked 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'].
    Last edited by lyronne; 03-18-04 at 08:11.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    http://support.microsoft.com/default...b;EN-US;270119 to followup the issue and resolve.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Posts
    6
    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...

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    The only option to suspect is about compatible/proper driver from Postgres, have you tried on Postgres website for any information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Mar 2004
    Posts
    6
    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.

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Try with latest version of MDAC and OLEDB provider.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Mar 2004
    Posts
    6
    Will try...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •