Informix 64 Bit Odbc Driver
This content is no longer being updated or maintained. The content is provided “as is.” Given the rapid evolution of technology, some content, steps, or illustrations may have changed.
- Informix 64 Bit Odbc Driver Windows
- Informix 64 Bit Odbc Driver For Oracle
- Ibm Informix 64 Bit Odbc Driver
- I am trying to create a linked table in a 64-bit SQL Server to Informix, and the SQL server does not list Informix ODBC in the DSN list. I have downloaded the 64-bit Informix Client SDK, however, despite the fact that it states 64-bit Informix Client SDK, it only appears in the 32-bit ODBC DSN.
- Progress DataDirect’s ODBC Driver for IBM Informix offers a high-performing, secure and reliable connectivity solution for ODBC applications to access IBM Informix data. Our ODBC driver can be easily used with all versions of SQL and across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX.
- IBM Informix began. Open Database Connectivity (ODBC) library. Client SDK (CSDK) version 2. UNIX® platforms such as AIX®, HP- UX, Solaris, and so on. Linux® and Windows®, Informix. How do I install a 32 bit version of ODBC to work with IBM Informix. Informix 32 bit ODBC setup for Microsoft. 32 bit ODBC driver on a 64 bit.
From the developerWorks archives
Date archived: May 13, 2019First published: May 01, 2014
Migrating 32-bit Informix ODBC applications to 64-bit. From the developerWorks archives. Yunming Wang. Date archived: May 13, 2019 First published: May 01, 2014. Informix® 64-bit ODBC driver binaries have been available for many years, but the true 64-bit Informix ODBC driver was not introduced until Informix Client SDK v4.10 in early 2013.
Informix® 64-bit ODBC driver binaries have beenavailable for many years, but the true 64-bit Informix ODBC driver was not introduced untilInformix Client SDK v4.10 in early 2013. This article discusses thedifferences between the Informix 64-bit binaries of the Informix ODBC driver and the newer, true64-bit driver. Also learn how to migrate your current 32-bit or 64-bit Informix ODBC applications to takeadvantage of the true 64-bit driver.
This content is no longer being updated or maintained. The full article is provided 'as is' in a PDF file. Given the rapid evolution of technology, some content, steps, or illustrations may have changed.
Currently trying to setup a development environment which can handle both 32-bit and 64-bit ODBC Informix Drivers.
I'm was unsuccessful at finding any sort of guide or walk through online, however I did find bits and pieces which could lead to the solution. I'd just like a little more advice to ensure I'm on the correct path.
Driver Versions
Version 3.70.TC3, Windows (32 bit)
Version 3.70.FC3, Windows x64
I can't seem to find versions 3.70.TC3 or 3.70.FC3, but I did find 3.70.TC7 and 3.70.FC7 directly from the IBM website, which I assume are just slightly updated versions.
Informix Driver Installations
The drivers are installed at the following locations (based on the registry entries)
- 32-bit: C:Program Files (x86)IBMInformixClient-SDK
- 64-bit: C:Program FilesIBMInformixClient-SDK
Registry Entries
Adobe premiere pro cc free. No, Premiere Pro is our most up-to-date version and the only version of Premiere Pro you can download for a free trial. Do students get a discount if they decide to purchase after the free trial? Yes, students and teachers are eligible for a big discount on the entire collection of Creative Cloud apps — 60% off. Apr 09, 2019 Adobe Premiere Pro CC 2019 Free Download offline installer 32/64-bit for Windows 10, Windows 7, Windows 8, 8.1, and Mac. It is the full offline installer standalone commercial trail setup direct single click download of Adobe Premiere Pro CC 2019 v13.0.
From what I can see, the registry entries for the drivers are located at:
- 32-bit: HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INI
- 64-bit: HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INI
This essentially lists all of the data sources and their connection details. Both locations have the same number of data sources with the same names and same key/value pairs, with the exception of the Driver key which points to it's respective driver location; C:Program Files or C:Program Files (x86).
ODBC Administrator
The 32-bit ODBC Administrator is found at %systemdrive%/Windows/SysWoW64/odbcad32.exe
Counterintuitively, the 64-bit ODBC Administrator is found at %systemdrive%/Windows/System32/odbcad32.exe
ODBC.INI
Informix 64 Bit Odbc Driver Windows
The ODBC.INI file is located at C:Windows where the contents of that file lists the same data sources as those displayed in ODBC Administrator, and includes the key/value pair of the 32-bit drivers for each of those data sources; Driver32=C:Program FilesIBMInformixClient-SDKbiniclit09b.dll.
Now what's interesting here is that although the key Driver32 is used, the value points to the C:Program Files path as opposed to the C:Program Files (x86) path, thereby associating the Driver32 to the 64-bit drivers.
I found the following page to explain this irregularity.
The WOW64 registry redirector intercepts calls made to certain portions of the registry and redirects them to another portion of the registry. Registry redirection affects the HKEY_LOCAL_MACHINESOFTWARE key. Registry calls made to this key by 32-bit applications are redirected to HKEY_LOCAL_MACHINESOFTWAREWow6432Node. So, for example, when a 32-bit application calls SQLDataSources, the resultant registry call is redirected from HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INI to HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INI, and the only system data sources that are returned are ones for 32-bit ODBC drivers.
Simply put, a 32-bit application which connects to the 64-bit ODBC drivers will automatically be redirected to the 32-bit drivers based on the registry entries, whereas a 64-bit application will need no such redirection.
If a 32-bit application attempts to connect to a valid user data source for a 64-bit ODBC driver, the connection will succeed if a 32-bit version of the driver is installed. Otherwise, the connection will fail with the 'architecture mismatch' error. For example, Microsoft’s SQL Server ODBC driver installs both a 64-bit library (%WINDIR%System32sqlsrv32.dll) and a 32-bit library (%WINDIR%SysWOW64sqlsrv32.dll) on 64-bit Windows platforms.
In the case of Informix, the driver for each architecture MUST be installed separately.
Questions
What is the importance of the ODBC.INI file, and can I simply modify the Driver32 key to Driver64 or maybe have both in conjunction?
Informix 64 Bit Odbc Driver For Oracle
When executing the 32-bit ODBC Administrator and opening a data source I am able to modify the connection settings, however when executing the 64-bit version I receive the following error.
How can I change the system's current ODBC Administrator to the 64-bit version in order to avoid this error?
1 Answer
The issue was that I had installed the 3.50 version initially. This version is no longer supported and also does not have a 64-bit counterpart.
Ibm Informix 64 Bit Odbc Driver
The resolution was to install the latest 4.1 drivers.