The following bug has been logged on the website:
Bug reference: 10223
Logged by: Soobia Arshad
Email address: soobia.arshad@tranchulas.com
PostgreSQL version: 8.4.19
Operating system: linux
Description:
I am maintaining postgresql database in linux 64 bit machine and sql server
2012 on windows 64 bit. I wanted to create a linked server in sqlMS for
which i installed ODBC driver in windows. When i use
C:\Windows\System32\odbcad32.exe then test connection is successful but
sqlMS gives me architecture mismatch error. and when i used
C:\Windows\SysWOW64\odbcad32.exe then postgresql is not listed in its driver
list under system DNS tab so i am unable to set up a DNS source. Where am i
going wrong? how can i link a 64bit postgreql to 64bit sql server?