- Install Informix Jdbc Driver Windows
- Ibm Informix Driver
- Avaya Informix Odbc Driver
- Informix Jdbc Driver Windows Download
Active2 years, 1 month ago
The Informix drivers are used by off box tools that connect to Unity Connection 2.1(1) or later systems via the database proxy service. The help files for each tool that uses the remote database proxy service to attach to Connection has instructions for how to configure the remote ODBC access from off box. It is also possible to obtain the version of the JDBC driver contained in the ifxjdbc.jar file from the command line. BEFORE YOU BEGIN Make sure you have set the CLASSPATH variable correctly to include the location of ifxjdbc.jar ( or ifxjdbc-g.jar ) and that your PATH has the JDK in it. STEPS Execute the following. Java com.informix.jdbc.Version. IBM Informix JDBC Driver IBM® Informix® JDBC Driver is a native-protocol, pure-Java driver (Type 4) that supports the JDBC specification. For information about JDBC specification compliance, go to Java™ software development kit. The suggested install directory for 32 bit CSDK is 'C:Program Files (x86)IBM Informix Client SDK'. Once the CSDK installation is completed, access the ODBC administrator utility located at 'C:WindowsSysWOW64odbcad32.exe'. Now, when you access the Drivers Tab of the ODBC Administrator, the IBM Informix Driver is visible. I'm trying to install the Informix ODBC drivers on Windows 7 64-bit so I can run the Wallet Card Wizard. I am getting the following error: 'Prerequisite verification checks failed InstallAnywhere has detected that you are installing the 32 bit.
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
https://yellowtee.weebly.com/blackberry-messenger-for-windows-10.html. 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
Install Informix Jdbc Driver Windows
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
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?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?
MPaulMPaul
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.
The resolution was to install the latest 4.1 drivers.
MPaulMPaul
Not the answer you're looking for? Browse other questions tagged driversodbcinformix or ask your own question.
Active7 years, 6 months ago
I've attempted this with ODBC drivers, and JDBC drivers. I'll list both approaches separately.
I'm using the ODBC driver found here: http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2007-11-02+09%3A22%3A41.038818R&S_TACT=&S_CMP=
It's the Informix Connect 32bit program. I've tried the 64bit version, stand alone it will connect, but the ODBC will not work with OpenOffice (32bit to 64bit issue). I've then decided to use the 32 bit version.
After installing the ODBC driver, I used C:WindowsSysWOW64odbcad32.exe to setup the driver in windows 7, it connected successfully.
Loading OpenOffice.org base I was able to use the ODBC to connect, but no tables are being listed. If I run a SQL query, I get this error:
JDBC approach
I can't use design view, since no tables are listed. Abandoning this, I used the JDBC driver, found here: http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2005-03-09+16%3A56%3A12.268164R&S_TACT=&S_CMP=
This was more successful, but I still can't get tables to list. Here's the errors I get when I run the OpenOffice.org BASE file:
I don't understand how that would effect the JDBC so greatly. I can however execute SQL queries without a problem. I can't use design views.
In the end, all I'm trying to do is have a useful GUI that I can build and debug queries with. If OpenOffice.org is a poor choice, I'm still open to other options. But the opensource prospects are ideal.
Lastly, this isn't directly a programming question, is there a better forum I should be using?
Thanks
kevingreenkevingreenIbm Informix Driver
1,33811 gold badge1616 silver badges4040 bronze badges
1 Answer
You can search for some general ODBC Editors/Designers.
I think that for JDBC there are more tools. You can use Eclipse with Data Tools Platform. Have a look at: Database Development in Eclipse with the Data Tools Platform (DTP) . It shows schema with tables, columns, etc.
I use simple ODBC editor done by myself for various ODBC tests but I also use Python with
odbc
module or even better Jython than can work with native JDBC drivers and ODBC drivers by JDBC-ODBC bridge. You can see such code at my SO questions like: Problem with Informix JDBC, MONEY and decimal separator in string literalsCommunity♦
Michał NiklasMichał NiklasAvaya Informix Odbc Driver
42.6k1414 gold badges5959 silver badges9494 bronze badges