locked
Postgresql as linked server in SQL Server using MSDASQL ole db provider RRS feed

  • Question

  • Postgresql server can be added as linked server  Microsoft Sql Server .

    Connection status is success.

    Query 1:  select * from openquery(XYZ,'select * from People')

    Status :  Success

    Query 2: select * from XYZ.NewDB.[public].People

    status: FAiled. 

    Error :

    OLE DB provider "MSDASQL" for linked server "XYZ" returned message "ERROR: cross-database references are not implemented: "NewDb.public.people";
    Error while executing the query".
    Msg 7306, Level 16, State 2, Line 1
    Cannot open the table ""newDB"."public"."people"" from OLE DB provider "MSDASQL" for linked server "xyz". 

    Please help..

    Thanks in Advance...

    Thursday, December 10, 2020 12:43 PM

All replies

  • Hello Rajump,

    The purpose of this forum is to support the Open Specifications documentation. You can read about the Microsoft Open Specifications program at https://msdn.microsoft.com/en-us/openspecifications/default. The library of Open Specification documents is located at https://msdn.microsoft.com/library/dd208104.aspx.
     
    It doesn’t appear that you are implementing one of the protocols cited. if you are working with a specific on-the-wire Windows protocol please provide additional information regarding which protocol so that we can better understand how we can assist you.

    We suggest posting your question to the following forum, with an appropriate tag:

    https://docs.microsoft.com/en-us/answers/products/sql-server


    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open Specifications

    Thursday, December 10, 2020 4:39 PM