Print Page | Close Window

too many client tasks?!

Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart Standard / PRO / SQL
Forum Description: All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=430
Printed Date: March/18/24 at 9:22pm
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com


Topic: too many client tasks?!
Posted By: lertie
Subject: too many client tasks?!
Date Posted: September/22/05 at 1:27pm
OK, our shopping cart pages periodically die and we get this message...


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

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

/mall/dynamic.asp, line 160


We've talked to the web host numerous times and they say it's a shopping cart problem. They've told us to either convert the Access database to mySQL (is that compatible and what code do we have to change on which pages?) or to make sure the database connection gets closed (where and how do we add that?)...

Help!
PS - this is Sales Cart Pro 5 on Dreamweaver hosted on a Windows 2003 server



Replies:
Posted By: Techno Geek
Date Posted: September/22/05 at 3:24pm
Yep, this is a common issue amongst the Windows 2003 customers. Here is one MS Article: http://support.microsoft.com/default.aspx?scid=kb;en-us;154869 - http://support.microsoft.com/default.aspx?scid=kb;en-us;1548 69

We do close the connections on a number of pages. For example on receipt2.asp you'll see it:

<%     Set SimpleAdo = Nothing

     Set RS = Nothing
     Session.Abandon
%>


You can try using a System DSN, though that would end up giving you the same results. I don't think switching to MySQL would work, at least not yet and I'm sure the code would have to change so the syntax is compatible with MySQL.

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support


Posted By: lertie
Date Posted: September/23/05 at 10:53am
Um, ok... so how do we FIX this??

The MS article you mentioned makes it sound like we're on a server that's being used too much by other sites and/or processes... Do we have to switch to a different server?

If not, do we add the code above to the end of all of the cart pages? That won't break the process sequences? And how does it differ from the code below?

Code:
<%     Set SimpleAdo = Nothing
     Set RS = Nothing
     Session.Close
%>



Posted By: Techno Geek
Date Posted: September/23/05 at 1:51pm
That code is already there so you can tell your host to chill out and not try to blame the software...

Try switching to a System DSN and see if that helps.

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support


Posted By: lertie
Date Posted: September/23/05 at 1:56pm
What's a DSN, and how will that fix the problem?

You said "that would end up giving you the same results" so how sure of a fix is it?

Is this a problem of being on a server that's too busy? or stuff that's not configured correctly on the server? or stuff that needs to be reconfigured in our cart?



Posted By: Techno Geek
Date Posted: September/23/05 at 2:12pm
This is a combination of many things:
  1. Server hardware
  2. Server OS
  3. Number of concurrent connections made to the database
  4. How many other websites using the drivers


DSN Defined:

Short for Data Source Name. Data Source Name provides connectivity to a database through an ODBC driver. The DSN contains database name, directory, database driver, UserID, password, and other information. Once you create a DSN for a particular database, you can use the DSN in an application to call information from the database.

There are three types of DSNs:
(1) System DSN -- can be used by anyone who has access to the machine. DSN info is stored in the registry.

(2) User DSN -- created for a specific user. Also stored in the registry.

(3) File DSN -- DSN info is stored in a text file with .DSN extension.

DSN is often used by Active Server Pages (ASP) and Visual Basic programs when a query to a database is necessary to retrieve information.

There is also what is known as a "DSN-less connection." Instead of using a DSN to connect to a database, the developer specifies the necessary information right in the application. With a DSN-less connection the developer is free to use connection standards other than ODBC, such as OLE DB.

I recommended that you try to use a DSN. You other alternative it to use a SQL database.

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support


Posted By: lertie
Date Posted: September/23/05 at 2:33pm
OK, we were hoping for a more comprehensive description - although you were very thorough.

Is this a problem of being on a server that's too busy?

How do we use/add a DSN? Do we do it or does the host?

It sounds like it's just another connection method... doesn't SalesCart already have ODBC conection scripting? If the server is saying there are too many tasks, how is that going to solve the problem?


Posted By: Techno Geek
Date Posted: September/23/05 at 4:10pm
Quote Is this a problem of being on a server that's too busy?


We don't know. It is possible.

Quote How do we use/add a DSN? Do we do it or does the host?


If the host provides a control panel, then you might be able to setup the ODBC Datasource. If not, then the host can setup the DSN and point it to /fpdb/shop.mdb (make sure that you setup a username and password on there).

Quote It sounds like it's just another connection method... doesn't SalesCart already have ODBC conection scripting? If the server is saying there are too many tasks, how is that going to solve the problem?


Out of the box it will use the DSN-less connection but you can switch the a DSN. With the DSN you would be using the system resources and that could help the issue.

One other possiblity is to ask the host to Isolate your website in the application pool and disable the session recycle and the web garden. That should help the issue.


-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support


Posted By: lertie
Date Posted: September/23/05 at 4:45pm
Well... the host doesn't support DSN connections - only DSN-less.

They are going to try the option of isolating the site in the application pool.

Not sure about the session recycle and the web garden yet...
not even sure what they actually are either :^P


Posted By: Techno Geek
Date Posted: September/26/05 at 11:27am
You can read more about the IIS 6 application recycle and web garden here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconperformanceapplicationpoolsettings.asp - http://msdn.microsoft.com/library/default.asp?url=/library/e n-us/cpguide/html/cpconperformanceapplicationpoolsettings.as p

If they do isolate the pool, Web gardens should be disabled for your application pool and worker processes should be set to 1. That should fix the issue for you.

And let us know how it works after the changes are made for you!

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support



Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.04 - http://www.webwizforums.com
Copyright ©2001-2015 Web Wiz Ltd. - http://www.webwiz.co.uk