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

  • 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?

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply