MSSQL 64bit connect to 32bit DSN.

We are migrating a DB project from MSSQL 2005 32bit/Windows 2003 to MSSQL 2005 64bit/Windows 2008.    We do not have a 64 bit ODBC driver to connect to our Progress database yet.  I have installed the driver under wow6432 ODBC DSN.   The issue I am having is that I can not get the Link Server to link to the 32 bit DSN.   Is there a work around for this? Currently we use a stored procedure using the Link Server entry to pull data into the MSSQL database for reporting.
LVL 4
edwardqAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
grayeConnect With a Mentor Commented:
Sorry to tell you this, but....    there is no easy solution to your problem.
I've got a similar situation where I routinely link to Microsoft Access (and Excel) files using the "Linked Server" feature.   However, since there is no 64-bit OleDb driver, we can't directly connect to those files.
The solution (if you call it that)... is to install a 32-bit instance of SQL Server along side your 64-bit version.   You'd configure the two SQL Server instances to allow for "distributed queries".   Then you'd use the 32-bit version as a "pass-thru" to get to the legacy databases.
I've heard that you can even install the free SQL Server Express Edition to act as the 2nd 32-bit instance.... (although, I've never tried that)
Obviously getting native 64-bit support for your legacy database is a much better solution (if that's at all possible)
0
 
edwardqAuthor Commented:
This is not the solution I used. I'm giving credit for providing a posible solution.  I had to get a 64bit driver to do this directly.
0
 
Ted-SCommented:
SSIS is another way to get 32bit data into 64bit SQL Server
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.