After calling SqlFreeSession() on a valid session handle, the next time SqlCreateSession() is called for the same session properties, it fails with the error:
Code: Select all
Neither the isolation level nor a strengthening of it is supported.
This problem occurs both with Oracle 9i and 11i OLEDB.
Here is an example log. As you can see, the retry attempt to connect the second time succeeds. It's always like this. For every disconnect you get a failed subsequent connect.
Code: Select all
12:30:01.28 - Preparing to connect (Provider=OraOLEDB.Oracle;Password=***;User ID=gen;Data Source=wab///)
12:30:01.39 - Connect success!
12:30:08.67 - Preparing to disconnect...
12:30:08.67 - Disconnect success!
12:30:10.94 - Preparing to connect (Provider=OraOLEDB.Oracle;Password=***;User ID=gen;Data Source=wab///)
12:30:13.80 - SqlCreateSession(...) FAILED!
12:30:13.80 - Connect FAILED!
12:30:16.41 - Preparing to connect (Provider=OraOLEDB.Oracle;Password=***;User ID=gen;Data Source=wab///)
12:30:16.45 - Connect success!
Can anyone confirm this please? Thanks.