| Gary Buckmaster 2006-10-25, 8:17 am |
| 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/...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
|