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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-25 : 08:43:40
|
Dharma writes "Hi there!
I am using ADO begintrans and commitrans/rollback trans in ASP pages. I need to know what is the connection mode and Isolation level and other properties to be given in order to work with ADO transaction. Since when 2 users are using or starting the transactions, I think the tables are getting locked, and both the users are getting the "SQL-SERVER - timeout expired error. One more point I want to add is I am keeping the Connection object in the ASP Sesssion, because the transaction is spread out in many pages.
Please help me.
Regards,
Dharma." |
|
|
|
|
|
Need Settings for using Transaction