Home » Infrastructure » Windows » ADO Recordset Locking in Oracle DB!
ADO Recordset Locking in Oracle DB! [message #100062] Wed, 03 July 2002 00:04 Go to next message
mingway
Messages: 1
Registered: July 2002
Junior Member
Hi All,
I am tring to use the ADO Recordset LockType of adLockPessimistic to lock one record in multi-user environment. It works fine on SQL Server with SQL ODBC driver. But i am tring it on Oracle server with a Oracle ODBC driver, it doesn't lock the record. I am thinking the oracle driver doesn't support this kind of locking, is it? Anybody knows this problem or recommends some kind of driver which has this feature?

Thank you very much!

mingway
Re: ADO Recordset Locking in Oracle DB! [message #100242 is a reply to message #100062] Thu, 19 September 2002 07:00 Go to previous message
Dayananda shenoy
Messages: 1
Registered: September 2002
Junior Member
hai friend
even i am facing the same problem .
i am developing a application using vb 6.0 + oracle 8i ,but when working in multiuser environment my application fails on concurrent data access
if you get any solution to your problem please forward the same to me
at the mean time i will also try to find a solution for the same

dayananda shenoy
Previous Topic: Re: solution for JREW error on Pentium 4 installations
Next Topic: Re: trimming char to fit into date column ORA-01830
Goto Forum:
  


Current Time: Fri Nov 22 14:48:57 CST 2024