Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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@xxxxxxxxxxx) 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 table. 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...

.

Relevant Pages

  • Re: Insert Performance Degradation
    ... How to Monitor SQL Server 7.0 Blocking ... >I am guessing there is some sort of locking problem going on. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Queue Reader fails occasionally
    ... What if you run these commands manually from the subscriber using QA? ... I'm thinking is that it might be a locking (blocking) issue which you'd be ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: SSIS Packages fail, but takes a LONG time to end
    ... How to monitor blocking in SQL Server 2005 and in SQL Server 2000http://support.microsoft.com/default.aspx/kb/271509 ... Some failures roll back quickly and fail the package; ...
    (microsoft.public.sqlserver.server)
  • Re: Strange problem in insert record into the database
    ... If there is regular blocking, your page will probably time out. ... Wayne Snyder, MCDBA, SQL Server MVP ... "Alan" wrote in message ... >>>thousand of insert and select transactions from the database. ...
    (microsoft.public.sqlserver.server)
  • Re: Help with blocking on querying two joined tables
    ... > to SQL Server 2000 that query a view made up of two joined tables. ... > tables directly I still get the same blocking. ... If these tables are queried frequenly they should stay in cache. ...
    (comp.databases.ms-sqlserver)
Loading