RDBMS: SQL Server 2000 + sp4
Application: xyz

XYZ 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 string
b. somehow add SQLSetConnectAttr on the ODBC DSN
c. Somehow update the DLL file that ODBC uses to have SQLSetConnectAttr atrributes hardcoded
d. 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?