var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: timeout when accessing from asp script
i have an asp script that runs a stored procedure to backup my db
i get an error
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][SQL Native Client]Query timeout expired
if i run the sp directly in sql - it works -- where can i increase this timeout?
from your asp page u can use conenction.commandtimeout = <a larger value in seconds>
can increase it from IIS properties
How long does your stored proc take to run when you run the sp "directly in sql"?
a few minutes but the connection.timeout worked - thanks
I would caution against increasing commandtimeout. If you feel that is the best solution, I would advise to at least set commandtimeout back to it's default after you've completed your long-running script.