joejonsme Initié
Inscrit le: 05 Mai 2018 Messages: 5
|
Posté le: Mar Mai 22, 2018 8:02 am Sujet du message: How to handle a timeout issue running a SQL statement |
|
|
Hello,
I wrote a nice little ASP app a couple years ago that depends on another guy's database for user information.
The view it polls is now timing out on me fairly frequently and in addition to getting him to solve the problem, I'd like to try to handle the timeout more gracefully.
It's just simple query:
Set objRS = objConn.Execute("SELECT FirstName, LastName FROM vu_User_Info")
When it runs that, it's timing out- one of the tables the VIEW looks at is blocked.
I'm not very good at error handling yet, so can anyone give me a pointer on how to handle this one?
Please help
I didn't find the right solution from the internet.
References:
https://arstechnica.com/civis/viewtopic.php?t=291093
Video content service
Thank you |
|