home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 410 of 2,288   
   Robert Vabo to All   
   Isolation level on Ora 9i   
   16 Sep 03 13:19:33   
   
   From: rvabo@msn.com   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca