Posted - 06/27/2013 : 12:10:40
| We are migrating a system from AS400/DB2 to SQL 2008 R2 on a Win 2k8 x64 box. The databases are preforming as expected but I want to create a linked server from SQL to the AS400.
I have installed the drivers but it appears that SQL Server is looking for the drivers in the System32 folder instead of Syswow64.
When I run System32\odbcad32.exe the only drivers that are listed are SQL Server v6.x and Native Access Client 10. When I run Syswow64\odbcad32.exe I get all of the drivers loaded on the system, including the iSeries and Client Access ODBC drivers that I am intending on using.
Does anyone know how to get SQL Server to recognize my Syswow64 drivers?
BTW, not sure if it matters but my SQL is not installed on the C:\ of the server but a separate partition (F:\).
Here is a link to some screenshots.
Enterprise Systems Specialist