Re: Too Many Client tasks

From: Mark Schupp (mschupp_at_ielearning.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 08:40:01 -0700

You are either not closing database connections or there are just too many
concurrent users for MS Access to accomodate.

http://www.aspfaq.com/show.asp?id=2195 

-- 
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
<anonymous@discussions.microsoft.com> wrote in message
news:1bdaa01c45188$b4a2d970$a101280a@phx.gbl...
> This is the error I see in the asp pages.
>
>
> Microsoft OLE DB Provider for ODBC Drivers
> error '80040e4d'
>
> [Microsoft][ODBC Microsoft Access Driver] Too many client
> tasks.
>
> Basiclly all database access on all sites stop with this
> error until I reboot the server.
>
> There are no eventlog errors.
>
> Thanks,
> Brian
>
>
>
> >-----Original Message-----
> >On Sun, 13 Jun 2004 13:09:57 -0700, "Brian"
> ><anonymous@discussions.microsoft.com> wrote:
> >
> >>I have a problem with a web server that has about 125
> web
> >>sites on it. It appears that someone or several people
> >>are not closing their connections. I keep getting the
> >>error "too many client tasks" . I need to know if there
> >>is any way to troubleshoot this, like see what user has
> >>what connections open. It is not practical to go
> through
> >>all of the code since there are probably a thousand asp
> >>files on the server. Any help would be GREATLY
> >>appreciated. I've searched for help with no success.
> >
> >Post the full error and where you're seeing it.  If it's
> in the event
> >log post the event ID and source, if not, check the
> event log for a
> >corresponding error message.
> >
> >>The configuration is:
> >>Windows 2003 Standard Server
> >>IIS 6
> >>MDAC that was included with 2003 server.
> >
> >Access databases by any chance?
> >
> >Jeff
> >.
> >

Relevant Pages

  • Re: Reducing load for LAMP app?
    ... MySQL: as much as possible, he keeps query results in RAM, but ... His hoster says that Apache server is under significant load. ... Using apc is pretty much transparent, but memcached will require modifying your database abstraction layer using the memcached functions. ... With persistent connections, you must have the maximum number of connections *ever* required allocated *all of the time* - even if no one is using your server. ...
    (comp.lang.php)
  • Re: Slow connections & Select database
    ... we are having problems with slow connections on our informix database. ... I've tried both shm connections and tcp connections on the db server, and the shm are a bit slow but tcp are much worse. ... Changing sqlhosts to include an IP address only helps the client end of things find the server's IP address by avoiding a forward DNS look-up. ...
    (comp.databases.informix)
  • Re: How can I open an SQL database and be the only one who has access to it?
    ... you can determine how SS permits access to your server. ... SINGLE_USER allows one user at a time to connect to the database. ... controlled by the termination clause of the ALTER DATABASE statement. ... To allow multiple connections, the database must be changed to ...
    (microsoft.public.data.ado)
  • Re: Slow connections & Select database
    ... If you want to check for network latency, you can do a series of pingfrom the client to the server and if you want to get fancy, do a traceroute as well. ... Did Rosie try a different database? ... > we are having problems with slow connections on our informix database. ...
    (comp.databases.informix)
  • Re: SQL Newbie question w SBS 2003 - confused - what to use
    ... Your database files can exist in different locations. ... SQL Server will allow a large number of concurrent users, ...
    (microsoft.public.sqlserver.programming)