Database Results Error Too many client tasks (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


akalana -> Database Results Error Too many client tasks (1/15/2004 0:07:09)

I get this error messsage when I try to run a query on my MS Access DB on 2K Server.
I have re-imported the DB, re-created the global.asa and removed the connections (DNS), but I can't seem to get rid of this error.
I have been using a DRW and it was working fine, however all of sudden, this error has occured.
Any ideas would be appreciated.




Spooky -> RE: Database Results Error Too many client tasks (1/15/2004 0:53:22)

Typically it means just that - Access has reached its limit due to too many connections or connections not being destroyed.
Ensure you use a OLEDB connection, but you may be delaying the inevitable.
It *could* be a host issue, but its hard to say

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&safe=off&q=%22Too+many+client+tasks%22




akalana -> RE: Database Results Error Too many client tasks (1/16/2004 2:16:52)

I am trying to find a way to drop the connection that Access has with this error message:
Database Results Error
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

I realize per your posting, that it is related to the OBDC driver string.
So I have resorted to using OLEDB string.

Using Frontpage, I know we can edit the string.
Using FPs database connection wizard, I selected to create a custom definition:
Provider=Microsoft.Jet.OLEDB.4.0; Source=htdocs\fpdb\aetmain.mdb
I keep getting either ISAM error, or authentication failed when I try to verify this connection in Frontpage.
Is there a defined way for setting the OLEDB driver string in Frontpage through the custom definition of FP database connection wizards?




Spooky -> RE: Database Results Error Too many client tasks (1/16/2004 3:53:42)

An example would be (Change the global.asa file) :
Application("db_connection") ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("\fpdb\db1.mdb")




akalana -> RE: Database Results Error Too many client tasks (1/16/2004 9:37:03)

Spooky,
I just wanted to thank you.
That worked like a dream.
Thanks again.




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.03125