ADO Recordset Locking in Oracle DB! [message #100062] |
Wed, 03 July 2002 00:04 |
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 |
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
|
|
|