i dont know if this room is correct - time out on sql server

[sal21]

I use the code above to connect sql server but have in few case an "time out connection" is correct my string of connection on sql server? existis a method to bypass the prob?

Code: Select all

Set OCONN = New ADODB.Connection
OCONN.ConnectionTimeout = 0
SQL = "Provider=SQLOLEDB;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=" & T_DATABASE & ";Data Source=servername"
OCONN.Open SQL ', adAsyncConnect

[HansV]

If OCONN.ConnectionTimeout = 0 doesn't help, the problem is on the server side. The DBA can set a longer connection timeout in SQL Server Enterprise Manager.