Windows Forum

Ask something
Discussion Locked

sql timeout error

0 helpful
3 replies

by briang

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Microsoft OLE DB Provider for SQL Server er
ror '80004005' Timeout expired
/Default.asp, line 17
WE RECIVE THIS ERROR A LOT WE DON'T KNOW OF A WAY TO PREVENT IT . ANY HELP OU THERE .
OUR sql SERVER VERSION 7.0
DUAL 700 MHZ PROCESSOR
256 MEG RAM
20 GIG HARD DRIVES
NETGEAR 100 SWITCH

3 replies

by venkats

The ADO Connection and Command objects have their own 'TimeOut' settings. If the values are set to default, the connectivity to the database or the execution of the queries can get timed out. The 'TimeOut' properties of either the Connection or theCommand objects can be changed (increased) depending on where the time-out error appears, to solve the problem.

This discussion is closed to new replies.