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.IsolationLev el = adXactReadUncom mitted
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

https://www.gecko.no

[sybrandb@yahoo.com]

Re: Isolation level on Ora 9i

"Robert Vabo" <rvabo@msn.comw rote in message news:<3f66f1bf$ 1@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.IsolationLev el = adXactReadUncom mitted
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