Error -2147467259 trying to update Rdb

[Guest_imported]

I am working on a VB6 app using Rdb ODBC Driver connection to an Rdb database on an Alpha. I seem to be unable to get anything but a read-only/forward-only/client-side cursor recordset; I have tried several combinations of Recordset type, locktype, and server/client-side cursors. Anytime I attempt to update a value, I get error -2147467259 and the update fails.

Any ideas??

TIA,

Lee.
Lee
lee.meinhardt@smna.com

 

[Guest_imported]

Rdb 6.1-15
Oracle Rdb Driver (ODBC) v. 3.00.01.02
VB6 SP5
MDAC 2.6

I'm trying to access an Rdb database residing on an Alpha/OVMS server via TCP/IP and SQL Services. Many times when I try to connect I get an error that seems to be caused by SQL SRV authorization failures: other than the SQLSRV.LOG is there ny other way to find out what (if any) UID/PWD are actually being passed to SQLSRV?

On occasoin, I do manage to connect, but then I have difficulties trying to update data; either the rowsets have been set read-only (despite my request for Write or REad/Write access), or the update fails with an error saying that the requested cursor doesn't exist or has been closed.

Anyone have any idea what's going on here, or where i can start to try to nail down and fix whatever is actually happening?
Lee
lee.meinhardt@smna.com