Solved

MSSQL 64bit connect to 32bit DSN.

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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Change administrator password on server 13 87
Need to fill description field on AD by PowerShell from a list of users 2 32
AJAX pass along a variable 3 46
SQL Syntax 14 34
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

790 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