<div>
This is not the solution I used. I'm giving credit for providing a posible solution. &nbsp;I had to get a 64bit driver to do this directly. 
</div>


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.

<div>
SSIS is another way to get 32bit data into 64bit SQL Server
</div>


SSIS is another way to get 32bit data into 64bit SQL Server

<div>
<div class="content wysiwyg-content">
We are migrating a DB project from MSSQL 2005 32bit/Windows 2003 to MSSQL 2005 64bit/Windows 2008. &nbsp; &nbsp;We do not have a 64 bit ODBC driver to connect to our Progress database yet. &nbsp;I have installed the driver under wow6432 ODBC DSN. &nbsp; The issue I am having is that I can not get the Link Server to link to the 32 bit DSN. &nbsp; 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. 
</div>
</div>


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. 

MSSQL 64bit connect to 32bit DSN.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.