Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
salowist
Starting Member
2 Posts |
 Posted - 2013-06-27 : 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.[url]http://www.anony.ws/g5O[/url]Steve SalowitzEnterprise Systems Specialist |
|
|
salowist
Starting Member
2 Posts |
Posted - 2013-07-03 : 14:49:29
|
| It turns out that the driver that I was trying to use was not x64 compatible. For anyone in need, you need to have iSeries Client Access v5r4 (with a service pack) or higher.Steve Salowitz |
 |
|
|
|
|
|
x64 drivers not recognized