Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Too Many client tasks error?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Too Many client tasks error?

 Post Reply Post Reply Page  12>
Author
808Rider View Drop Down
Senior Member
Senior Member

Vebro Solutions CEO http://www.vebro.net

Joined: 20 April 2003
Status: Offline
Points: 405
Post Options Post Options   Thanks (0) Thanks(0)   Quote 808Rider Quote  Post ReplyReply Direct Link To This Post Topic: Too Many client tasks error?
    Posted: 04 May 2003 at 5:41pm

I just got this error when I try to go to my forum page and was wondering if anyone knows what it means. I did correct it by downloading and compacting my database and then uploading it, but I would really like to know the meaning of this error and if anything special can be done to prevent it.

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks

It also shows a comment referring to line 232 of the common.asp file

This is what line 232 is in common.asp: adoCon.Open

Thanks In Advance

Back to Top
Trevni View Drop Down
Groupie
Groupie


Joined: 24 February 2003
Location: United States
Status: Offline
Points: 149
Post Options Post Options   Thanks (0) Thanks(0)   Quote Trevni Quote  Post ReplyReply Direct Link To This Post Posted: 04 May 2003 at 9:34pm
Do you get that error all the time or once in a while?
Does your forum get a lot of hits?
Aslo if you are using a DSN connection try using DSN-Less connection for this. It seems to be a common error with the system DSN database.

Edited by Trevni
Resident immature brat...
Back to Top
808Rider View Drop Down
Senior Member
Senior Member

Vebro Solutions CEO http://www.vebro.net

Joined: 20 April 2003
Status: Offline
Points: 405
Post Options Post Options   Thanks (0) Thanks(0)   Quote 808Rider Quote  Post ReplyReply Direct Link To This Post Posted: 04 May 2003 at 10:28pm

Today was actually the first time I received this error. I only have about 60 forum users right now, but a lot of my users have been on the forum at the same time and after starting my forum about two months ago, this was the first time I ever received this error. Also I am already using the DSN-less connection to my database.

Does this error mean too many users on the forum at once or is it just something I have to prevent by compacting my database often?

Back to Top
Trevni View Drop Down
Groupie
Groupie


Joined: 24 February 2003
Location: United States
Status: Offline
Points: 149
Post Options Post Options   Thanks (0) Thanks(0)   Quote Trevni Quote  Post ReplyReply Direct Link To This Post Posted: 05 May 2003 at 1:30am
Yes it is possible to have too many queries at once. This is an Access database side effect, though I don't know much about Access limitations and if 60 users would be a bit too much for it to handle. If you rarely get this error you can live with it, if you get it all the time you might have to look into using MSSQL.
Resident immature brat...
Back to Top
PrimeraRacer View Drop Down
Groupie
Groupie


Joined: 29 January 2003
Location: United Kingdom
Status: Offline
Points: 83
Post Options Post Options   Thanks (0) Thanks(0)   Quote PrimeraRacer Quote  Post ReplyReply Direct Link To This Post Posted: 05 May 2003 at 10:21am

I used to get this error all the time, I dont think its about how many users you have but more to do with how many users are using the forum at once. I think its getting overloaded because of the limitations of access.

Anyway, the answer to your question is really to upgrade to the SQL version, thats what I did and have never had the error since!!

Cheers

Kev

Back to Top
Trevni View Drop Down
Groupie
Groupie


Joined: 24 February 2003
Location: United States
Status: Offline
Points: 149
Post Options Post Options   Thanks (0) Thanks(0)   Quote Trevni Quote  Post ReplyReply Direct Link To This Post Posted: 05 May 2003 at 3:44pm
Great to know that someone can rephrase everything that I have just said in the previous post.
Resident immature brat...
Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post Posted: 06 May 2003 at 4:57am

umm i dont think its got out to do wit an overload or out

cose i get the error on a site where AM the only one on it,

it isnt the forum, but its the same error

i know this is the Forum Support part, and not the ASP part,

but sumone already posted it  so i guess i dont need to post it again

or do i have to? 

anyway i get the same error on my site, not usin the forum, but its only me, and at the most 2 others, it doesnt have 2 much info in the Database, could it be that ive accessed the database 2 much on the page?

Back to Top
kbannon View Drop Down
Groupie
Groupie


Joined: 03 October 2002
Location: Ireland
Status: Offline
Points: 115
Post Options Post Options   Thanks (0) Thanks(0)   Quote kbannon Quote  Post ReplyReply Direct Link To This Post Posted: 07 May 2003 at 2:25am

I am getting the same error on version 6.28 - I think I sorted it by changing the conn string from...
strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ......
to...
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="......

if I converted the database from Access to MySQL would it have the same difficulties from too many people using the forum?

Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.