Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
Hi all,
I am getting this error while trying to insert a record into the database ta
ble. We are using SQL SERVER 2000/ODBC/ASP combination.
I would really appreciate if somebody could help me regarding this.
thank you.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...Could be different things. The first thing to check for
would probably be locking, blocking issues on SQL Server.
You can use sp_who2 to identify blocking. You can use
sp_lock to see what types of locks are occurring, you can
also query sysprocesses in master. You'd probably want to
start with these and go from there.
-Sue
On Tue, 18 Oct 2005 11:12:24 -0700, latha
(rc_forum@.hotmail.com) wrote:

>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>[Microsoft][ODBC SQL Server Driver]Timeout expired
>Hi all,
>I am getting this error while trying to insert a record into the database t
able. We are using SQL SERVER 2000/ODBC/ASP combination.
>I would really appreciate if somebody could help me regarding this.
>thank you.
> ****************************************
******************************
>Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
>Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resourc
es...sql