How to set isolation level at run time?

[cywong119]

Dear All,

I make use the DSN of Progress ODBC driver to connect to Progress Database in my Visual Basic Programm/Application.
For generating reports, I need to set the Isolation Level of the DSN to "Read Uncommitted" so that user can view all data of table A while other users are updating table A.
For add/update table record, my program need to set the Isolation Level of the DSN to "Read Committed" or "REPEATABLE READ" in order to maintain data integrated. Another reason is when the isolation level of the DSN is set to "Read Uncommitted", my program can not perform adding/updating record into table.

So, my questions are:
1) Can my program set the isolation level of the DSN at run time?
2) If so, how to set the isolation level of the DSN at run time?

Can anybody advise me?

Christine

 

[miura]

Hi, I have same problem,too.
Sorry, my English is very poor,so please guess what I mean.
You can not change Isolation level in a same session.
If you want to change Isolation level, you should generate another session.
You might use ADO ,RDO etc,why don't you make two kind of odbc,
one is "Read Uncommited",the other is "Read Commited" or "REPEATABLE READ" .
You can set "Default Isolation Level" using ODBC Setting (Control Pannel)

Regards, Miura

P.S Have you adjusted -L option? (for lock table size)