Too many client tasks

[Andy Ogden]

I am writing a site that uses an ODBC link to a database, the code
below is used to retrieve data from this database. I have had reports
of the following error.

ERROR [08004] [Microsoft][ODBC Microsoft Access Driver] Too many
client tasks. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed

I have included the code in question below, as you can see it takes in
a string containing an SQL statement. The returned data is then
returned within a DataView object. No other code in the site accesses
the database, so the problem must be in this code.


Can anyone help, I'm stuck



private DataView GetDataView(string szSQL)
{
string szConnection= "DSN=tif";
DataSet objDataSet= new DataSet();
OdbcConnection objDBConn = new OdbcConnection(szConnection);
OdbcDataAdapter objDataAdapter = new OdbcDataAdapter();
objDataAdapter.SelectCommand = new OdbcCommand(szSQL, objDBConn);
objDataAdapter.Fill(objDataSet);
DataView objDataView= objDataSet.Tables[0].DefaultView;

objDBConn.Close();

return objDataView;
}

[Brian]

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.

The configuration is:
Windows 2003 Standard Server
IIS 6
MDAC that was included with 2003 server.

Thanks,
Brian

[Jeff Cochran]

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

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
>.
>

[Mark Schupp]

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

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

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


<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
> >.
> >

[Jeff Cochran]

On Sun, 13 Jun 2004 13:55:06 -0700,
<anonymous@discussions.microsoft.com> wrote:

>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.

Sounds like it's time to upgrade to SQL Server or at least MSDE. May
also be related to the Jet bug, if you call Microsoft support thay
have a beta fix for this.

Jeff

>>-----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
>>.
>>

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.
>
>[url]http://www.aspfaq.com/show.asp?id=2195[/url]
>
>--
>Mark Schupp
>Head of Development
>Integrity eLearning
>[url]www.ielearning.com[/url]
>
>
><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
>> >.
>> >

>
>
>
>.
>