Solved

MSSQL 64bit connect to 32bit DSN.

Posted on 2008-10-07
4
914 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need help on t-sql 2012 10 55
Sql server insert 13 32
SQL Server - Set Field Values ito Zero Based on Related Table 4 28
performance query 4 24
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

821 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