Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dance Doll
Yak Posting Veteran
54 Posts |
 Posted - 2007-06-13 : 14:42:14
|
| RDBMS: SQL Server 2000 + sp4Application: xyzXYZ connects to SQL Server via ODBC System DSN lets say XYZ_ODBC_DSN. My objective is any connection that uses XYZ_ODBC_DSN should only do uncommited read.Any idea how I can do this? My application is 3rd party app and I can't change their code and can't changed their procs to have set transaction_isolation level . only options I have is a. somehow add SQLSetConnectAttr on the connection stringb. somehow add SQLSetConnectAttr on the ODBC DSNc. Somehow update the DLL file that ODBC uses to have SQLSetConnectAttr atrributes hardcodedd. Registry hack may be.Question is a. Is it possible to do this in any of the above 4 options?b. If yes, any example we have or anybody knows? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-13 : 15:17:28
|
| You need to work with the vendor on this as any change like this could violate their contract with you, which would mean that they wouldn't have to support you if there were issues.Why have you selected uncommited read?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2007-06-13 : 15:23:19
|
| vendor app is 100% reporting app and it is connecting to our OLTP. It is also poorly written. if two or three people running reports it just blocks each other. |
|
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2007-06-13 : 15:31:42
|
| However the question is.... Is it possible to add attributes to ODBC? or change the attribute of a particular login to do only read uncommitted? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-13 : 22:00:34
|
| It's set at session level. |
|
|
|
|
|
|
sql server ODBC and SQLSetConnectAttr