Posts Tagged ‘Linked Server’

Postgres Linked Server How To

Posted on January 30, 2010, 4:44 pm, by Rhys, under DBA.

Just a quick post showing how to add a Postgres database server as a Linked Server in Microsoft SQL Server.

Install the psqlODBC driver for Windows.
Control Panel > Administrative Tools > Data Sources (ODBC).
Click the "System DSN" tab and click the Add button.

Choose "PostreSQL ANSI" and click Finish.
Configure the data source by [...]

Tags: , , ,
No Comments | Read the rest of this entry »