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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 x64 drivers not recognized

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 Salowitz
Enterprise 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
Go to Top of Page
   

- Advertisement -