How to install Informix ODBC on Windows Server 2003/2008

asp.netinformixodbcwindows-server-2003windows-server-2008

I installed the Informix Client SDK on my PC (32 bit) and on the server. I could create an ODBC connection on my PC easily, but on both Windows 2003 and 2008 (64 bit) I can't.

I don't know if there is a 64 bit SDK; maybe this is the issue. But I haven't found what to do.

I need to use ODBC since using the SDK by itself hangs IIS, and according to this post, the solution is to use ODBC.

thanks

Best Answer

I have found the way.

The problem was that the server is 64-bit, and my workstation is 32-bit.

The IIS application is 32-bit, so the ODBC connection must be 32-bit as well.

To access 32-bit ODBC on 64-bit Windows, you should execute c:\windows\syswow64\odbcad32.exe instead of c:\windows\system32\odbcad32.exe.

Now I can add the data connection for Informix.

Hope this helps someone out there.

UPDATE: this is not working with Windows Server 2008 :(

Related Topic