Currently trying to setup a development environment which can handle both 32-bit and 64-bit ODBC Informix Drivers.
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. 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.
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.
Php tutorial for beginners with examples ppt free download. Teach your friend (Optional)Teaching is a great way of learning. You will improve day by day.What will you learn?Here's more about what will you learn in this complete guide. What is PHP?. If you have a friend who is interested in PHP, teach him/her what you learned and discuss more.
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
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
32-bit Odbc
Counterintuitively, the 64-bit ODBC Administrator is found at %systemdrive%/Windows/System32/odbcad32.exe
ODBC.INI
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.
Download THX Optimizer 2.0 ISO torrent or any other torrent from the Video Other. Direct download via magnet link. Get Certified. THX Certification is a globally recognized assurance of uncompromising quality, consistency and performance. We blend art, technology and the dynamics of real world viewing environments to ensure products deliver the artist’s true vision. Sep 19, 2019 Free thx optimizer download software at UpdateStar - Microsoft Windows may have got more advanced but the need for effective maintenance is greater than ever. Thx optimizer download. Dec 21, 2010 THX Optimizer HD – Video Tests: White Detail Setup Black Level Setup Tint / Hue Setup Color Setup Picture Performance Aspect Ratio And Scaling THX Optimizer HD – Audio Tests. THX Video Calibration Tool by CalMAN 3.7. THX Video Calibration Tool by CalMAN is a fully multi-threaded computing environment that takes maximum advantage of available hardware, including multi-core processing, to provide faster meter measurements, faster graphing, and faster user input response.
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?
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?
Informix Odbc Driver Windows 64 Bit
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.
32 Bit Informix Odbc Driver
The resolution was to install the latest 4.1 drivers.