Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Nov 23, 1999

Setting the Timeout Parameter

Question:
I am converting a database from Access to SQL. It is a large database—some 4.5GB large.

I get a timeout (1 minute) before I get my response back. Can I change the timeout parameter, or is there a way to program a longer delay?

Answer:
You can set the time-out parameter from the ODBC manager. I wonder what is causing it, though, because with a 4GB database, how much of the conversion is logged? How long between commits? Or just what is causing the delay?

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date