question

ahelbling33 avatar image
ahelbling33 asked

Linked server issue with PostgreSQL

Hello, I am attempting to create a Linked Server in SSMS 2005 SQL Server. I have installed the ODBC driver for the remote PostgresSQL server and can connect with no problems. The problem is with the Linked Server set up process. I get this error. Any help appreciated. TIA, Andrew ![alt text][1] ![alt text][2] [1]: /storage/temp/360-capture1.jpg [2]: /storage/temp/361-capture.jpg
sql-server-2005postgresql
capture1.jpg (27.6 KiB)
capture.jpg (104.5 KiB)
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
Could you mark the response as answered so that other people find the solution useful?
1 Like 1 ·
ahelbling33 avatar image ahelbling33 commented ·
Thank you!
0 Likes 0 ·
sp_lock avatar image sp_lock commented ·
Did it resolve your issue?
0 Likes 0 ·
ahelbling33 avatar image ahelbling33 commented ·
yes it did.
0 Likes 0 ·

1 Answer

·
sp_lock avatar image
sp_lock answered
It looks like you are using the SQL server OLE provider and not the ODBC one Have you also read http://www.postgresonline.com/journal/archives/103-Using-Microsoft-SQL-Server-to-Update-PostgreSQL-Data.html
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.