Isolation level on Ora 9i

[Robert Vabo]

I have an VB6 application using transactions. The database is Oracle 9i and
I use the native Oracle OLEDB provider to access data.
When I use the this code:

cn.IsolationLevel = adXactReadUncommitted
cn.BeginTrans

I get an error message with number -2147168248 telling me that the isolation
level is not supported. I use this on COM+.

If I use the Microsoft OLEDB driver for Oracle it works, but I am handling
BLOBs containing documents so I have to use the native driver.

What kind of isolation level is supported on Oracle 9i ?

--
Regards
Robert Vabo
Gecko AS
www.gecko.no

[sybrandb]

"Robert Vabo" <rv***@msn.com> wrote in message news:<3f********@news.wineasy.se>...

I have an VB6 application using transactions. The database is Oracle 9i and
I use the native Oracle OLEDB provider to access data.
When I use the this code:

cn.IsolationLevel = adXactReadUncommitted
cn.BeginTrans

I get an error message with number -2147168248 telling me that the isolation
level is not supported. I use this on COM+.

If I use the Microsoft OLEDB driver for Oracle it works, but I am handling
BLOBs containing documents so I have to use the native driver.

What kind of isolation level is supported on Oracle 9i ?

Goto http://tahiti.oracle.com and search on isolation level.
My fee for doing your work and answering mere doc questions is $200 per hour.

Sybrand Bakker
Senior Oracle DBA