Solved

MSSQL 64bit connect to 32bit DSN.

Posted on 2008-10-07
4
917 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

A procedure for exporting installed hotfix details of remote computers using powershell
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

687 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