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 ofc:\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 :(