Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002

    Unanswered: Need Help With ADO Recordset.addNew & OLE DB

    I have no problem using the provider "IBMDADB2" for connection and inserting record using dynamic SQL; however, everytime I use the Recordset.addNew method, I kept getting the error message " Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.". I've tried all the combination of currsor_type & lock_type, but it still does not work.

    Does anyone know if the OLE DB Provider for DB2 support Recordset.addNew method, specially Recordset.appendChunk to insert BLOB. Any JAVA example or configuration tips are appreciated.

    Quoc Truong

  2. #2
    Join Date
    Nov 2002
    We found that setting the following to work

    .ActiveConnection = con
    .CursorLocation = adUseServer
    .CursorType = adOpenStatic
    .LockType = adLockOptimistic
    .Open sSQL

    However, if the table has a BLOB or CLOB, you have to leave them out of the query and update them separately.

  3. #3
    Join Date
    Aug 2002

    Re: Need Help With ADO Recordset.addNew & OLE DB

    There's a doc of IBM.
    will be helpful to know the limitaion of DB2 V7.2 OLEDB Driver.
    (With DB2 V8 , a lot of these limitations will be removed.)

    From this doc, AddNew is supported ( but as Cursor Service ).
    appendChunk is also supported .
    BLOB or CLOB of OLEDB is not supported as of V7.2 .
    ( OK in V8 )

    Hope this may help .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts