Too many client tasks

Unable to download drivers

[Stephen Tiller]

Hi everybody

We run a website where a section enables users to download various drivers. It has been working fine for 2 - 3 months but today I get the following error message. We use MS access as the backend;

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC Microsoft Access Driver]Too many client tasks.

/downloadsection/www/downloads/index.asp, line 30

I have tried researching this on the Internet but there is not much to go on. I have redone the section but I still get the same error message.

Can anybody help me on this one?

Thanks

Steve

[bakedjake]

Are you closing your database connections in ASP?

[Stephen Tiller]

Yes

I am using ASP code, and Dreamweaver and MS Access.

[bakedjake]

Can you post the code that you're using to open, close, and retrieve your DB info?

[Stephen Tiller]

This is my latest try, I haven't had time to check it for errors yet, as I finish work now and will be away tomorrow. But this code did not work either.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="../../../Connections/akhdownloads.asp" -->
<%
Dim RSNEWDOWNLOADCATS
Dim RSNEWDOWNLOADCATS_numRows

Set RSNEWDOWNLOADCATS = Server.CreateObject("ADODB.Recordset")
RSNEWDOWNLOADCATS.ActiveConnection = MM_akhdownloads_STRING
RSNEWDOWNLOADCATS.Source = "SELECT * FROM DownloadCats"
RSNEWDOWNLOADCATS.CursorType = 0
RSNEWDOWNLOADCATS.CursorLocation = 2
RSNEWDOWNLOADCATS.LockType = 1
RSNEWDOWNLOADCATS.Open()

RSNEWDOWNLOADCATS_numRows = 0
%>
<%
Dim rsnewdownloads__category
rsnewdownloads__category = "*"
If (Request("category") <> "") Then
rsnewdownloads__category = Request("category")
End If
%>
<%
Dim rsnewdownloads
Dim rsnewdownloads_numRows

Set rsnewdownloads = Server.CreateObject("ADODB.Recordset")
rsnewdownloads.ActiveConnection = MM_akhdownloads_STRING
rsnewdownloads.Source = "{call qdownloads('" + Replace(rsnewdownloads__category, "'", "''") + "')}"
rsnewdownloads.CursorType = 0
rsnewdownloads.CursorLocation = 2
rsnewdownloads.LockType = 1
rsnewdownloads.Open()

rsnewdownloads_numRows = 0
%>

.
.
.
<%
RSNEWDOWNLOADCATS.Close()
Set RSNEWDOWNLOADCATS = Nothing
%>
<%
rsnewdownloads.Close()
Set rsnewdownloads = Nothing
%>

[bcolflesh]

PRB: Error "Too many client tasks" When Using Jet:

support.microsoft.com/default.aspx?scid=kb;en-us;154869

also check:

support.microsoft.com/default.aspx?scid=kb;en-us;q306518

[Stephen Tiller]

Many thanks for your help on this problem.

I have now fixed it by simply restarting the server.

Steve