Setup a linked server from SQL 64-bit to 32-bit ODBC database

• Marker

  SSChasing Mays

  Points: 602

  More actions

  January 27, 2016 at 10:01 am

  #74803

  I'm looking for a solution to create a linked server from my SQL 2008R2 Server running on Windows 2008R2 server to my 32-bit Pervasive database running on a Windows 2008R2 server. I created a ODBC system DSN using the exe (32 bit version) from the SYSWOW folder and the connection tests fine. When I attempt to create the linked server in SSMS I'm getting an architectural mismatch. I've learned this is because SSMS is 64-bit and will not talk to a 32-bit ODBC connection. After doing some research I found a 3rd party software that seems to create a "bridge" called Easysoft ODBC-ODBC bridge that will let me get from my 64-bit SQL server application to my 32-bit ODBC driver. I have not tested it, and the software is $1,300. The goal is join databases from 2 databases (SQL Table and PSQL Table) by creating a view on the SQL server. I'm being told that going the linked server route isn't recommended due to performance. We would be better off creating a SSIS to dump the data from PSQL into a table on the SQL server and join them every 30 minutes for example? If that is the case, a SSIS package can be forced to launch in 32-bit mode?

• frederico_fonseca

  SSCoach

  Points: 16226

  More actions

  April 17, 2016 at 8:16 am

  #1872597

  Persavise does have a 64bit client - can't you use it?

  Regarding the 32bit execution of SSIS packages you can do it - probably you will need to execute it from the command line so you can specify the 32 bit version of dtexec.