navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Database Results Error Too many client tasks

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Database Results Error Too many client tasks
Page: [1]
 
akalana

 

Posts: 15
Joined: 10/17/2003
Status: offline

 
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

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
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

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to akalana)
akalana

 

Posts: 15
Joined: 10/17/2003
Status: offline

 
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?

(in reply to Spooky)
Spooky

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
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")


_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to akalana)
akalana

 

Posts: 15
Joined: 10/17/2003
Status: offline

 
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.

(in reply to Spooky)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Database Results Error Too many client tasks
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts