asked on 5/15/2011

How to add timeout to connection string

Where should the timeout seconds be entered in the connection string for exequeting a query on the below connection? I need 120 seconds...

Dim cn As OleDbConnection
Const strCN As String = "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;User ID='';Initial Catalog=MyTable;Data Source=BS-120471\SQLEXPRESS;Initial File Name='';Server SPN=''"

Visual Basic Classic VB Script

Last Comment

brutaldev

5/15/2011

ASKER CERTIFIED SOLUTION

brutaldev

5/15/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

kgittinger

5/15/2011

ASKER

Is there any chance you could provide an example of this connection builder at work? I am unsure about adding the "connections timeout"

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Sample.mdb;User ID="Admin;NewValue=Bad"

THanks!

brutaldev

5/15/2011

You can simply change your connection string to:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Sample.mdb;User ID=Admin;NewValue=Bad;Connect Timeout=600
The default is 15 seconds (the example sets it to 10 mins). You can set it to zero to be unlimited but of course this is not not recommended.

What I meant by using the builder is for a SQL Server connection string, you can load your string in and then change it via easy to see properties. EG:

Dim builder As New SqlConnectionStringBuilder("Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;User ID='';Initial Catalog=MyTable;Data Source=BS-120471\SQLEXPRESS;Initial File Name='';Server SPN=''")
builder.ConnectTimeout = 600
' Set more properties here.

Using conn As New SqlConnection(builder.ToString())
	conn.Open()
...
End Using

Open in new window

.ToString() it when you're done to get the connection string it represents. Unfortunately the OleDbConnectionStringBuilder does not have the properties as nicely defined.