May 28, 2008 at 5:33 pm
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
May 28, 2008 at 9:32 pm
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?
May 29, 2008 at 12:07 pm
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