Thanks again for your help, but it is still not working !
I changed the provider from MSDAORA to {Microsoft ODBC for Oracle}, the CursorLocation to adUseClient ... I tried severa combination of cursor & lock types I can't see what I am doing wrong ...
This time the error message is "unspecified error" - source provider.
(By the way I am using Oracle 8i with VB6.
The Oracle datatype is CLOB.)