Sounds good on posting back to this forum. Thanks for the new NoLock SQL syntax, it will come in handy for future coding projects.
I was able to get my app to work properly simply by setting the ODBC Driver to Read Committed. After tedious testing it appears that no locks are created when...
I am looking to do the same thing. I however currently do this.
I have 2 odbc connection strings, one is set to read uncommitted and the other to serializable for their default isolations. On all select statements I use the read uncommitted connection string, but when I want to insert or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.