ODBC / Access 97 front end for Informix 7.22.TC2 -Reply

Thanks to those who replied. It turns out that the Informix CLI / Intersolve drivers, according to Intersolve Tech support, have a "confirmed omission" (>not< 'bug') of the update cursor. This is to be corrected by Intersolv in 2 - 3 weeks. Does anybody know how long it typically takes Informix to reissue the CLI Drivers, once they have been changed by Intersolv? Or does Informix now 'own' this version of the drivers, and will they need to make the enhancement themselves? Puzzled in Phoenix ... -- Sky >>> Sky Southwell 05/30/97 03:24pm >>> We are attempting to port an Access application from pure Access to an application which will have an Access97 user interface, but will have Informix 7.22.TC2 as the DB. This is to buy us time until a full rewrite can occur. We are getting an ODBC Error #3146 with our application. We have been able to select and insert, but we cannot update. Has anyone encountered this error? Do we have a problem with our ODBC settings, or is there a problem with our ODBCDirect string?: Set RS = consPubs.OpenRecordSet("select * from Authors where LastName = 'Smith', dbOpenDynamic, 0, dbOptimistic) TIA -- -- Sky +-------(southwel@smtpgw.maricopa.gov)-------+- Maricopa County -+ | Schuyler L. Southwell | Attorney's Office | | Data Management Consultant | 301 W. Jefferson | | Voice: 602-506-8107 **** FAX: 602-506-3970 | Phoenix, AZ 85003 | +--------------------------------------------+--------USA--------+