Solved

ASP and Access.... Too many client tasks.

Posted on 2000-03-21
9
454 Views
Last Modified: 2008-02-01
I hv an ASP site.. and I keep getting this error frequently...
what is the cause ???
too many users?
how can I increase this?

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

Thanks..
0
Comment
Question by:Haho
  • 4
  • 3
  • 2
9 Comments
 
LVL 4

Expert Comment

by:jkunal
ID: 2643088
Check your DSN....
It may be misconfigured to use Windows NT security instead of SQL Server standard security,pl change it.

;->
0
 
LVL 4

Expert Comment

by:FRehman
ID: 2643263
when you open your recordset please use cursor type "lockoptimistic"option so user can edit one record at one time and also check that no one enter with name as some one already present in your site
0
 
LVL 1

Author Comment

by:Haho
ID: 2669032
Adjusted points from 50 to 100
0
 
LVL 1

Author Comment

by:Haho
ID: 2669033
hi guys,

this is the code where it fails:
< this is a global include file >

DSN = "filedsn=" & sPath & f & ";DefaultDir=" & sPath & ";DBQ=" & Path & DB & ";"

Set con = Server.CreateObject("ADODB.Connection")

con.Open DSN <===== HERE!!!

I am increasing the points so that u guys can have a more accurate look..
Thanks!
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 4

Expert Comment

by:FRehman
ID: 2671829
when you make file dsn then save it where it say to save and only write that which is below for open the recordset

  Set cn = Server.CreateObject("ADODB.Connection")
  'Open a connection; the string refers to the DSN
  cn.Open  "FILEDSN=MyDatabase.dsn"
then it will not generate any error I also work it
0
 
LVL 4

Expert Comment

by:jkunal
ID: 2671849
Try a DSN less connection.
0
 
LVL 1

Author Comment

by:Haho
ID: 2678609
frehman,

so are u saying that a DSNless connection has a much lower concurrent capability than one with a ODBC DSN ?? That is why u suggest to me to change from DSNless to using a DSN?

please comment.

Thanks

PS. jkunal: I am already using a DSN-less connection here.
0
 
LVL 4

Accepted Solution

by:
FRehman earned 100 total points
ID: 2678784
you can access the database from three ways one from without any dsn second is use file dsn and third one is system dsn the code which you paste here is use file dsn . I think you use system dsn any it also connect the database I simply correct you code and write the exact syntx of statment if you find still in accessing the database  problem then let me know at leo_faisal@yahoo.com
0
 
LVL 1

Author Comment

by:Haho
ID: 2723445
thanks, but the problem I discovered was because of the server CPU utilization...using too many resources..
leaving other sites with not enough system resources(including connections)...

another possible reason is the limitation of earlier Jet drivers... documentated in Microsoft site.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Classic ASP + JS 4 82
two submit buttons one form 15 76
Using querystring in a hyperlink 3 46
is this a cms? 8 36
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now