sql server - Is it possible to change default OLEDB connection timeout value? Run-time error (80040e31) -
i have 1 legacy app (vb) , have issue timeout error while connecting sql server (probably through oledb).
using sql profiler figure out connection dropped through 30 seconds.
i don't have access source codes scanned exe resources , couldn't find hardcoded connection string timeout values there.
the last chance think have change default oledb timeout somewhere outside app.
my question is: possible change default oledb timeout value?
update
i found connection string , changed timeout 300 not help...
provider=sqloledb.1;persist security info=false;user id=______;password=______;initial catalog=________;data source=______;connect timeout=300
after tried replace current connection string connection strings different providers: ado.net , odbc every time timeout error after 30 seconds - checkmate.
p.s.
i'll happy advice
connect timeout limit of time connect server, not execute command, setting not @ all
Comments
Post a Comment