Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2014
    Posts
    7

    Unanswered: Linked Server Data not showing

    Hi,

    I have a linked server that was built on PostgreSQL database connection. When I try to query one of the tables in the linked server it is giving attached error. Please suggest what could be the error.
    Attached Thumbnails Attached Thumbnails error0.JPG  

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I am not sure, but it looks like you may not have this set up as a PostgreSQL connection. The error seems to say the connection is expecting another SQL Server on the other side. Can you check the linked server settings to see what provider it is using?

Posting Permissions

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