Issues with linked server

  • I created a linked server from SQLServer 2005 to a PostGres database.

    I created and tested the ODBC I created and then created the LinkedServer without error messages.

    However when I try and run ANY query against the linkedserver I get the following error message -

    Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server

    We had this setup in test and I was able to create without a problem.

    Why would this happen on this server?

    Need help ASAP as we just upgraded a thirdparty software and can't verify the upgrade until I can get the queries running.

    Thanks in advance

    Susan

  • I am not sure whether or not SQL Server 2005 can link to PostGres database.

    Did you use sp_testlinkedserver to check the link?

    Did you test your DSN before configure the linked server?

  • I had created a UserDSN (and it tested fine) for the linked server.

    When I created a systemDSN it worked.

    So yes, you can connect from SQL Server to Postgres.

    Thanks for everyone's help

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply