SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 x64 drivers not recognized
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

salowist
Starting Member

USA
2 Posts

Posted - 06/27/2013 :  12:10:40  Show Profile  Reply with Quote
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.

http://www.anony.ws/g5O

Steve Salowitz
Enterprise Systems Specialist

salowist
Starting Member

USA
2 Posts

Posted - 07/03/2013 :  14:49:29  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000