devxlogo

ODBC drivers for Informix IDS 9.2

ODBC drivers for Informix IDS 9.2

Question:
We are trying to get our application to work with Informix using ODBC, and we are having repeated failures. We cannot seem to access “memo” (large text) fields of any type using the supplied ODBC driver, version 3.31. We are on an NT system, and we have tried both MFC and raw ODBC with CLOBs, CHARs, LVARCHARs, and TEXT field types, but still it fails. Incidentally, we have no problems with SQL Server or Oracle.

1. Are there any other ODBC drivers we could try, and if so, does anybody know where we might find them?

2. Has anyone else had similar problems with memo fields and ODBC and found any solutions?

Answer:
ODBC drivers are by necessity a “least-common-denominator” solution. Informix has no “memo” data type. The closest I can think of is text, and if it doesn’t work with your version of ODBC, you’re probably out of luck for a while. The Informix-CLI/SDK usually installs several versions of the ODBC driver. Try them all and see if one works better.

See also  How HealthStream Learning Center Supports Healthcare Education and Compliance
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist