Re: intermitent connection problem asp to sql2000
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 02/03/05
- Next message: Robbe Morris: "Re: Use Access mdb or Access project with SQL Server"
- Previous message: Sue Hoegemeier: "Re: Programmatically create DSN usind SQL Server Authentication"
- In reply to: John: "intermitent connection problem asp to sql2000"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 03 Feb 2005 12:02:48 -0700
You'd want to start by monitoring for locking, blocking
issues in SQL Server when you experience the timeouts. You
can monitor for these issues using sp_who2, sp_lock and
querying master..sysprocesses.
-Sue
On Tue, 1 Feb 2005 17:43:41 -0000, "John" <john@home.com.uk>
wrote:
>I have an asp page (w2003 IIS) which grabs a very small amount of data from
>a table on our
>sql server (sql2000).
>
>Most of the time the page works fine, with no problems. However
>intermitently it falls over with:
>
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>[Microsoft][ODBC SQL Server Driver]Timeout expired
>/MIS/Searches/main_search.asp, line 8
>
>
>this is the connection and query which brings back about 300 records:
>
>Dim MM_uLiveDatabase_STRING
>MM_uLiveDatabase_STRING = "dsn=database;uid=username;pwd=password
>Dim getID
>Dim getID_numRows
>
>Set getID = Server.CreateObject("ADODB.Recordset")
>getID.ActiveConnection = MM_uLiveDatabase_STRING
>getID.Source = "select fltf_value from caps_users left join
>caps_user_filters on uflt_for_user = user_id inner join caps_filter_fields
>on fltf_filter_flt = uflt_filter_flt where user_ref like '" +
>Replace(getID__theUser, "'", "''") + "'"
>getID.CursorType = 0
>getID.CursorLocation = 2
>getID.LockType = 1
>getID.Open()
>
>
>THis is rapidly becoming a major problem! Anyone got any ideas????
>
>john
>
- Next message: Robbe Morris: "Re: Use Access mdb or Access project with SQL Server"
- Previous message: Sue Hoegemeier: "Re: Programmatically create DSN usind SQL Server Authentication"
- In reply to: John: "intermitent connection problem asp to sql2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
