On 19 Apr 99, at 21:15, [log in to unmask] wrote:

>
> I have a Visual basic 6.0 program that uses ADO to access the
> HP3000 using ODBCLink/SE version 5.56.1200.  It retrieves records
> but I cannot update/delete/add records to the database.  I have
> added the user to the DBE and set it up for mode 1.  When I use
> the recordset.supports() function in VB UPDATE, DELETE, ADDNEW
> and UPDATEBATCH all return as false.
>
> Is there something special that needs to be done to allow
> updates to Image/SQL through the ODBCLink/SE driver?
>

You are most likely going throuh the Jet engine (probably 3.5 or
3.51) and this requires that the row have a unique index to permit
updates.  There is a way to fake out VB to make it believe that
this is the case.  I will try and locate a code example for you
later this morning.

Regards,
Jim
--
James B. Byrne                   [log in to unmask]
Harte & Lyne Limited             www.harte-lyne.ca
9 Brockley Drive
Hamilton, Ontario                vox: +1 905 561 1241
Canada  L8E 3c3                  fax: +1 905 561 0757