January 27, 2016 at 10:01 am
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?
April 17, 2016 at 8:16 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy