MSDE Connection or Command Timeout not changing
Posted on 2004-10-07
Working with VB6 and MSDE on 2 computers. I am trying to get the timeout to be shorter than the 60 seconds that it currently takes. I open a connection with Pessimestic locking and begin a transaction. I then start another instance of the same program which tries to begin the same transaction. The second program just hangs for 60 seconds exactly. Everything that I read tells me that the connection timeout is 15 seconds and the command timeout is 30 seconds. Changing these values has no effect on the 60 second delay until I get the 80004005 timeout error.
Is there some other timeout that I should be setting that will cut down on the delay? From a users view it looks like the system has locked up and they will probably hit the power switch before the system reports the timeout error. I just want some feedback from the system that the database is busy and please wait.