Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 http://forums.asp.net/p/1269896/2425034.aspx#2425034 the solution is to use odbc.

thanks

share|improve this question
add comment

1 Answer

up vote 5 down vote accepted

I have found the way

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

The IIS application works using 32 bits, so the odbc connection must be 32 bits as well.

to acces odbc 32 bits instead of 64 bits you should execute c:\windows\syswow64\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 :(

share|improve this answer
    
Which version of CSDK do you have on Windows Server 2008? Can you upgrade to 3.50.FC6 if you aren't already there? –  Jonathan Leffler Mar 20 '10 at 2:53
    
Note that both 32-bit and 64-bit CSDK (ODBC) drivers should be able to connect to either a 32-bit or 64-bit IDS server via a networking connection. The only time the client and server must use the same number of bits is when the shared memory connection mechanism is used ('olipcshm' or 'onipcshm'). Also check the support matrix; not all older versions of CSDK work on newer systems (like Windows Server 2008). –  Jonathan Leffler Apr 8 '10 at 23:48
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.