Informix Odbc Driver Windows 7

Active7 years, 6 months ago
Windows

I've attempted this with ODBC drivers, and JDBC drivers. I'll list both approaches separately.

Informix Downloads (Informix Client Software Development Kit for Mac OS X, 64-bit)A single packaging of several application programming interfaces (APIs) for rapid, cost-effective development of applications for IBM Informix servers. 4.10.FC9DE IBM Informix Connect is a runtime connectivity product that is composed of runtime libraries that are included in Client SDK. How to install an Informix ODBC driver on Windows 7 (for MS Office 2010) Feb 7,2011 1 Comment on How to install an Informix ODBC driver on Windows 7 (for MS Office 2010) Informix It was a struggle.

ODBC approach

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.

Driver

Informix Odbc Driver Windows 7

Lastly, this isn't directly a programming question, is there a better forum I should be using?

Informix Odbc Driver Download

Thanks

kevingreenkevingreen
1,3381 gold badge16 silver badges40 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 literals

Community

Odbc Drivers For Windows 7

Michał Niklas

Ibm Informix Driver 64 Bit

Michał Niklas

Informix Odbc Driver Windows 7 64 Bit

42.3k14 gold badges58 silver badges94 bronze badges

Informix 32 Bit Odbc Driver Windows 7

Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Ibm Db2 Odbc Driver Download

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