Solved

MSSQL 64bit connect to 32bit DSN.

Posted on 2008-10-07
4
912 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:edwardq
4 Comments
 
LVL 41

Accepted Solution

by:
graye earned 500 total points
ID: 22664796
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
 
LVL 4

Author Closing Comment

by:edwardq
ID: 31503856
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
 

Expert Comment

by:Ted-S
ID: 23222572
SSIS is another way to get 32bit data into 64bit SQL Server
0

Featured Post

Don't lose your head updating email signatures!

Do your end users still have the wrong email signature? Do email signature updates bore you or fill you with a sense of dread? You can make this a whole lot easier on yourself by trusting an Exclaimer email signature management solution. Over 50 million users do...so should you!

Join & Write a Comment

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now