[Microsoft][ODBC Microsoft Access Driver] Too many client tasks. (1 Viewer)

juanvan

New member
Local time
Today, 10:03
Joined
May 1, 2017
Messages
7
I am having a problem with the "Boss"
We have been using an Access DB for 20ish years (I know a good Run)
And Finally we have upgraded the servers from 2000 (*boo) to 2012 (YAYA)

We did a Lot of testing, and the server seemed to Do Ok, there were not any errors.

Fast forward a year give or take, and we are seeing Many
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
Now I know the problem is the number of connections to the database, but I have to PROVE with out a Shadow of a Doubt this is the problem.

I tried to find something in the Performance monitor but that is not helping.
I installed Total Access Admin
It shows 5 connections, but those are not tasks.
And those connections never close.
I am not sure what else to do, and it's driving me up a wall.

Any help to get my sanity back would be GREAT!!
Thank you for reading
//Rantish
 

juanvan

New member
Local time
Today, 10:03
Joined
May 1, 2017
Messages
7
Guess I should add this part.
Does the number of Connections Span the number of databaseS?

So if I have 10 Databases, does each connection count go towards the Number of Tasks?
 

HiTechCoach

Well-known member
Local time
Today, 12:03
Joined
Mar 6, 2006
Messages
4,357
What is the frontend created with? Mu guess would be not Access since you are detting on ODBC error.

If an Access front end, What version of Acess are you running? Are you linking the tables using the ODBC Driver not directly?
 

juanvan

New member
Local time
Today, 10:03
Joined
May 1, 2017
Messages
7
There is no linking of tables, the system is used like a glorified excel sheet.
Everything is a Read operation.
provider=microsoft.jet.OLEDB.4.0;
Is the connection string, it is in ASP Classic, this is a on a Websystem.

Thanks for the response.
 

HiTechCoach

Well-known member
Local time
Today, 12:03
Joined
Mar 6, 2006
Messages
4,357
Ah ... the errors are coming from Classic ASP page(s).

Is the database still int he older JET4 (.mdb) format?

When as the last time you backed up the database then ran a compact/repair? I would suggest doing that is yu have not tried it. It is alway good to do a backup first since yu are having issues.

FWIW: I run Classic ASP pages on a Wiindows 2012 Servers without any issues. Some use the MDB format. Others the ACCDB format.
 

juanvan

New member
Local time
Today, 10:03
Joined
May 1, 2017
Messages
7
Yes I have backups of all the Databases, they are saved else where.
Maybe I should repair them all and re-post them.

Ya the ASP Classic pages output an error from time to time.

I will try that and see how the day goes.
Going to take a while tho, there are 50+ of them.
 

juanvan

New member
Local time
Today, 10:03
Joined
May 1, 2017
Messages
7
Did the Compact to all the databases.
There are still errors going on.
I can see certain problems I might be able to test to further prove my point.
I am going to make those changes and report back.

Due Date of Wed.
 

juanvan

New member
Local time
Today, 10:03
Joined
May 1, 2017
Messages
7
Am Half way with the re-write, but my son was sick 2 days and had to be daddy daycare.
I hope to have more next week.
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 12:03
Joined
Feb 28, 2001
Messages
26,999
Earlier, you said you needed to determine the number of connections. Somewhere I was reading an article about FE/BE connections and that each .RowSource property on a form would add a connection. It was from before your question and I didn't make a bookmark for it, darn the luck.

If you wanted to enumerate the connections you had open, you might consider For Each loop counting (and naming) each member of Workspace(0).Connections (which is a collection of connections). You might also have to do a double-layer test, since each connection can theoretically have multiple recordsets open within it.
 

juanvan

New member
Local time
Today, 10:03
Joined
May 1, 2017
Messages
7
Thanks for the input Doc Man, but this is a Website not an application.
It's hard to count the connections when there are 100+ websites all using 1 connection string from the same IIS process.
 

Users who are viewing this thread

Top Bottom