Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Increasing timeout?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

suzypud
Starting Member

United Kingdom
12 Posts
Posted - 03 February 2004 :  06:00:00  Show Profile  Visit suzypud's Homepage
Is it possible to increase the timeout allowed when connecting to the database? I am using a MSSQL database which is located off site, and occasionally it is slow. I would rather increase the timeout than have users get an error. Is this possible?

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 03 February 2004 :  06:11:27  Show Profile  Visit HuwR's Homepage
you can set the commandtimeout and connection timeout properties on the connection

Myconn.CommandTimeout = 30
Myconn.ConnectionTimeout = 20

however, having the timeouts set too high will have an adverse effect on your sql servers performance
Go to Top of Page

suzypud
Starting Member

United Kingdom
12 Posts
Posted - 03 February 2004 :  09:40:53  Show Profile  Visit suzypud's Homepage
Where would be the best place to put the timeout properties? I mean, which file should I put it in? Or would I have to put it in all files?
Sorry if this is a stupid question!
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 03 February 2004 :  10:05:15  Show Profile  Visit HuwR's Homepage
where you open the connection, so inc_header at a guess
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000 Version 3.4.07