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.