ASP error - 'too many client tasks'
Feh ... so many ASP errors, so little time. Is anyone able to shed some light on why I might be getting the following error in my ASP discussion forum? The error appears in a long-ish thread - about 25 posts (the longest on the forum). It appears about 20 posts in and the rest of the thread does not display. Error is:
message by Sparklebug on 08 February 2002 at (**time should go here**)
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
/new_forum/date_time_functions.inc, line 144
Someone has told me this could be because of a slow DNS connection and said perhaps we should get a DNS-less connection ... Does this sound right and, if so, what does it mean and how do I sort it out??
Thanks as always.
Bug
Mark Hensler posted this at 04:10 — 18th February 2002.
He has: 4,048 posts
Joined: Aug 2000
I'm not an ASP guy, so this probably won't be of any help. But..
I've heard that Access isn't very desirable, especially for high traffic sites.
Is the error always at the same spot?
Mark Hensler
If there is no answer on Google, then there is no question.
Sparklebug posted this at 04:14 — 18th February 2002.
They have: 54 posts
Joined: Oct 2001
Yep - always in the same spot. And only started appearing a day or so ago - was fine before that.
I've not been able to do an 'on error resume next' where the error is appearing in the code because I'm not at work today and don't have access to the files. Will try that tomorrow.
I know Access isn't ideal, but we need to use it at the moment. Also the forum really doesn't get much traffic at all - about 50 members and a very small group of regular posters within that.
Bug
Abhishek Reddy posted this at 07:02 — 18th February 2002.
He has: 3,348 posts
Joined: Jul 2001
Just checking, do you mean DSN or DNS?
Your error might be generated by an infinite loop (usually that comes up as some sort of "out of bounds" error but still...), or since its a long thread your process mught just be crashing. I'm not too sure...
BTW, whats your code on line 144 like? It might help to know that.
Peter J. Boettcher posted this at 13:47 — 18th February 2002.
They have: 812 posts
Joined: Feb 2000
Yeah, it would help to see your code. If it's always happening in the same spot then I don't think its a client connection limitation, unless you're doing something funny with connections or something.
PJ | Are we there yet?
pjboettcher.com
openmind posted this at 19:13 — 18th February 2002.
He has: 945 posts
Joined: Aug 2001
R U hosting on cfm-resources.com by any chance? If so, there's your problem!
Sparklebug posted this at 22:45 — 18th February 2002.
They have: 54 posts
Joined: Oct 2001
Okay ... the error is either at line 66 or line 144 - both lines of code query the database as follows:
rsTimeFormat.Open strSQL, strCon
The table being queried, as you might guess, is where the formatting preferences for the date and time are kept.
I'm at work today (boo!) and have put 'on error resume next' before both of those lines. Now all of that thread shows up but from the point where the error message was appearing the date and times have returned to default formatting (dates in US order and not in full text - ie. 02/13/2002 rather than 13 February 2002 as I have my preferences set).
I'm more than happy to have the thread showing regardless of how the date appears. But if anyone is able to shed some light as to why the error might be occurring and how I can fix it I'd be mucho grateful.
Thanks again.
Bug
PS. Not hosting on CFM Resources - we use Webcentral in Sydney, Australia who everyone keeps telling me are very good ...
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.