Re: Too Many Client tasks

anonymous_at_discussions.microsoft.com
Date: 06/14/04 

Date: Mon, 14 Jun 2004 13:11:20 -0700

Thanks for the information. What I am really looking for
is some way to determine who is using the connections and
not closing them.
Does anyone know of a way to see how many access db
connections are open and who or what site has them open.
I know that it is someone not closing their connection
but I can't figure out who it is.
If I can determine that someone has serveral open
connections, I can tell them to check their code and
close the connections.

Thanks,
Brian

>-----Original Message-----
>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: Too Many Processes?
    ... > uses stored procedures extensively to access the data. ... I've been closing my connections after executing any data ... As long as you are correctly closing AND disposing of your objects when ...
    (microsoft.public.sqlserver.programming)
  • Re: How to gracefully (programmatically) kill an app?
    ... | closing the console window. ... want the server application to stop accepting connections. ... that server file maintenance can be done with the first event and a full ... In dictatorships, you need courage to fight evil; ...
    (microsoft.public.vc.mfc)
  • rblsmtpd/qmail-smtpd hung processes
    ... After a while the server just quits accepting smtp connections, or will connect/disconnect very quickly. ... Since I'm not seeing any log activity that shows what's going on, I'm having a hard time figuring it out. ... Our email/dns provider is closing up shop in about a week. ... I only had about 3 weeks notice on this and I've been configuring a pair of FreeBSD machines to take over DNS and E-Mail for about a dozen sites. ...
    (freebsd-questions)
  • RE: JDBC connections not closing
    ... | Thread-Topic: JDBC connections not closing ... | thread-index: AcTB1nv3W8xh6wDJQIK0wY6q4fuFig== ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: Issue with user profile folders and outlook
    ... I have received the Event Log and had a look at it. ... the SID should be resolved to the account name. ... Try to log onto the client with that account and check how it works. ... Connections, ...
    (microsoft.public.windows.server.sbs)
Quantcast