Can't connect to Informix from 64-Bit OS
Apr 16, 2007 02:30 PMandys987LINK
Once my System DSN for the 64-bit ODBC driver was set up (and tested OK), I set up a linked server using the Microsoft OLE DB Provider for ODBC Drivers. Linked Server: UCCX Provider: Microsoft OLE DB Provider for ODBC Drivers Product name: IBM Informix ODBC Driver (probably could be anything but I named it the same as the ODBC Driver and it. Grow your communities through Groups, promote and manage your events using Peatix's robust tools on the web and the app. Simple, transparent, low fees. Customer-centric support.
My migration to Windows Server 2003 64-bit was going pretty smooth until I tried to connect to our Informix DB.
- By default 64 bit Windows runs the ODBC Administrator Utility 64 bit instead of the the one that we just installed (32 bit), this causes the IBM INFORMIX ODBC DRIVER option NOT to be visible, you can find the ODBC Administrator Utility 32 bit at ‘ C: Windows SysWOW64 odbcad32.exe ‘.
- If you are installing the 32 bit version onto a 64 bit OS you might need to prepend the SysWOW64 path temporarily to your%PATH% variable or the install may bark at you. To do this open a comand prompt - be sure to run 'as administrator', go to the folder where the Informix SDK install is at and type: set PATH=C: WINDOWS SysWOW64;%PATH%.
I have installed the IBM Informix Client SDK. I went through setnet and set up the connections. I used the ILogin demo and tested it and it works. So I know that part is good.
In my application, I am using SQL Server Reporting Services to pull data from the Informix DB. In the old 32-bit environment it worked pretty well. To connect to Informix from a Reporting Services Data Source I should be able to use either OLE DB or ODBC. After testing both from Reporting Services on the new 64-bit machine neither worked. So I figured I'd make an ODBC connection manually and test it in the Admin tool. I could not find the drivers listed in the ODBC Data Source Administrator tool. But then I found some posts about using the administrator from this location: C:WINDOWSSysWOW64odbcad32.exe. So I figured I was on the right track. I used that tool, created the connection and tested it. It works. But still Reporting Services could not connect using that DSN, or even a fully figured ODBC connection string.
Ibm Informix Odbc Driver 64 Bit
Ibm Informix Odbc Driver Download Windows 64-bit
I also created a quick windows forms app to test with. From that app, I could not connect to the Informix database using OLE DB or ODBC. My guess is that the 64-bit OS doesn't know where to find the Informix 32-bit drivers that I am using. I can't find a download for the 64-bit drivers for Windows.
The exceptions thrown are:
- From ODBC test: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
- From OLEDB test: System.TypeInitializationException: The type initializer for 'IBM.Data.Informix.IfxConnection' threw an exception. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format.
Microsoft Odbc Drivers 64 Bit
Does anyone know how to resolve this?
Thanks, /download-age-of-mythology-the-titans-full-crack.html.
Informix Odbc Driver 64 Bit Download
-Andy