Delphi32.com -- FAQ - Unable to use IDE tools to access and/or update tables in Informix database

Unable to use IDE tools to access and/or update tables in Informix database

I am unable to access my Informix database via most of the IDE database tools (e.g. JDBC Explorer, SQL Builder, and Browse Table funtionality is lost)

It appears that with older Informix JDBC drivers (problem reported against .22.JC specifically), there is a communication breakdown that causes an invalid schema name, "informix", to be returned on the table. As most of the IDE database tools rely on the schema name when internally querying the table, this results in poor behavior:

) one will experience errors of the type: "the specified table (informix.) is not in the database" when attempting to open the table via JDBC Explorer's "Data" page
2) the table will appear to have no columns defined when inspecting via the "browse tables" dialog or the database tree in the left-hand pane of the JDBC Explorer
Note that queries can still be performed successfully either via code or via the "Enter SQL" page of JDBC Explorer.
The workaround for this problem is to update your JDBC driver to the latest available from the vendor. Visit the download area of Informix's website (http://www.informix.com), or go directly to http://www.intraware.com:8 /shop/product.html?PLNE=000 48 for more information on the latest JDBC drivers for Informix.
8/4/99 2:09:45 PM

<< Previous Faq Complete List Next Faq >>

Hits/month	2,500,000+
Downloads (Since May 2000)	7,393,709
Total Files	6,023
Forum msgs	7,670
Articles/FAQs	70+/900+

Kylix

Books

Top Selling Software at Amazon

Site Search: