troubleshooting Question

How to add timeout to connection string

Avatar of kgittinger
kgittingerFlag for United States of America asked on
Visual Basic ClassicVB Script
3 Comments1 Solution1154 ViewsLast Modified:
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=''"

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros