Connect 32bit ODBC datasource to 64Bit MS SQL Server 2008
Posted on 2011-05-10
I would like to import data from a legacy database (Sybase Advantage 8.1) into Microsoft SQL Server 2008 on Server 2008 R2. My preferred method for doing this would be to add the old database as a linked server in MSSQL and then write a few transformation and conversion scripts right there in SQL Server Management Studio. The problem is that you are apparently not supposed to be able to access 32 bit ODBC drivers from 64 bit SQL server. It seems to me like there should be some way to convert the calls and bridge that gap and that this would be a common problem, but I haven't found the solution. I can make the 32 bit ODBC connection on a 64 bit system by running "c:\windows\sysWOW64\odbcad32.exe" manually, which works, for example, for accessing the data from Excel, but I can't figure out how to get to it from SQL Server.