pgODBC on Win2k3 AS with MS SQL 2005

pgODBC on Win2k3 AS with MS SQL 2005

am 24.10.2006 16:33:12 von Gary Buckmaster

I'm in the process of setting up replication from a Win2k3 server
running MS SQL 2005 to a number of Postgres servers and am running into
some issues. I installed the 08_02_01000 release of the psql ODBC
drivers on the Win2k3 server, configured a System DSN. Effectively I
followed the instructions provided here:
http://people.planetpostgresql.org/mha/index.php?/archives/8 7-Replicating-from-MS-SQL-Server-to-PostgreSQL.html
for creating the DSN entry. I also created a linked server referencing
the Postgres server I eventually intend to replicate to. After creating
these two associations, I'm unable to execute queries on the linked
server and I suspect that I've not set up my ODBC association properly.
Since I've never done anything like this before, I'm not sure even how
to go about troubleshooting this issue. I would be appreciative of any
insight this list can provide on troubleshooting and/or setting up this
scenario.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster