ODBC Driver problem

"John Clynes" <jclynes@family.co.uk> writes: >Hi, >I am using Informix's CLI 2.5 ODBC driver (obtained from Online 7.23). >However, it seems the driver is pretty limited. From VB I cannot edit a >recordset using the edit or update methods. >The error I am getting is that the object or database is read-only. > >I can work around this, but am a little suprised that the driver is so weak. >Does anyone know of any better driver's knocking about? > >Thanks, >John > > John, 1. If you are writing code that uses recordsets in VB, then you are using the Access Engine (Jet) (as opposed to making direct calls to the ODBC API). Page 487, Windows Multi-DBMS Programming (John Wiley & Sons): "Jet requires bookmarks (primary keys) for updatability. If there is no unique index for an attached table, Jet creates a snapshot, which is not updatable. Jet treats attached views as attached tables without indexes, so it uses snapshots for views and queries based on views." 2. Complete list of ODBC drivers and vendors http://ourworld.compuserve.com/homepages/Ken_North/odbcvend.htm