July 12, 2004 at 6:58 pm
Does anyone know how to do
SET TRANSACTION ISOLATION MODE READ UNCOMMITTED
as part of a connection string?
I dont care about dirty reads but I really want to avoid any locking issues.
July 12, 2004 at 10:44 pm
You Can always pass the string as using Connection.execute method or us command object to do the same. This can be done after the connection is successfully opened.
July 12, 2004 at 11:01 pm
I was looking for a way to do this when you dont have the source code for the application (i.e configuring a 3rd party application or a reporting tool).
Maybe I should ask this in another forum?
July 13, 2004 at 1:21 am
"set transaction isolation level read uncommitted" is used to avoid waits for locked resources.
table hint (NOLOCK) can be used to avoid read locks on resources.
IMO you should contact your 3rd party to find out if and how you can provide parameters for the application to use this stuff.
I don't know if you can add parameters to odbc or oledb configurations so the default connection type is read uncommitted.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply