Informix ODBC Drivers 3.31

Informix ODBC Drivers 3.31

Question:
I am currently running Informix Dynamic Server 2000 version 9.20 TC1 on an NT server, Service Pack 6a. I have existing Visual Basic 5 applications that are using ADO 2.1 to connect to the Informix Database using the new Informix 3.31 ODBC drivers.

When the VB applications try to update a table, I get the following error message:

    Error 3251. The operation requested by the application is not supported by the provider. ADODB.Recordset in updaterow.

The updates work just fine if I use the Informix 3.11 ODBC driver. The suggestions that Informix tech support provided me were no help on this issue. Do you have any suggestions?

Answer:
I’d say stay with 3.11 for a while. There are usually some compatibility problems with Informix’s ODBC drivers (maybe it’s an ODBC thing). There were significant problems with the 2.80 drivers, from the reports I saw. These issues seem to usually lag about one release behind.

As a general rule, being the somewhat conservative, “I know it’ll break” kind of guy that I am, I try to stay away from the current release of most software products until it’s been out for a while. They all have these issues.

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular