If this is a shared hosting environment you can expect that. CF has problems on shared hosting environments any website on the server can execute a sloppy query and bring down the server, and you with it. Who is the ISP? I had this problem with Intermedia, they said that one of my pages were too blame. I moved to another ISP and found the page was working fine and I even called support and asked him to monitor the CPU while I and a few other people used the same page and there was no increase in the CPU activity. So obiviously I was on a machine that was not properly configured at Intermedia.
I asked a similiar question to Ben Forta during the question period at the CFNorth Conference and his answer was simply don't use shared hosting at this time with coldfusion if the site is mission critical. But if dedicated hosting is out of your budget, I found that crystaltech is reliable and affordable. Just my two cents. Mike ----- Original Message ----- From: "Edward J. Bebee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 4:47 PM Subject: [CFTALKTor] CFQUERY - is it buggy? > Hi All; > > We're having an issue with our ISP over CFQUERY & Databases and I > was hoping some of the people here can bring some light to this problem or > confirm if we're nuts or what. > > Here's the problem: > > We run several sites with this ISP. And they seem to run fine most of the > time but lately, at least twice a day and often more, we hit this error: > - - - - - > ODBC Error Code = 08004 (Data source rejected establishment of > connection) [Microsoft][ODBC Microsoft Access Driver] Too many > client tasks. > - - - - - > > When the error occurs, it's often not limited to one site/domain. For > example, when "Client_A.com" hits the error, often *ALL* the domains we host > at this ISP encounter the error. When the problem clears up a few minutes > later, it clears up for all the domains as well. This sounds like server > behaviour to me. Possibly a bad ODBC driver. Who knows? > > The ISP thinks we've been smoking a lot crack lately, denies this happens > across more than one domain and blames it on CFQUERY. > > CFQUERY, I'm told, doesn't properly open and close database connections. > Those open connections build up and --- whammo! --- "Too many client tasks" > error happens when using CFQUERY. To close the connection, we should be > sending a fake query (below) to generate an error which will trigger a > closure of the database. > > The fake query: > <cfquery datasource="YourODBCDataSource"> > Select BadData FROM UnknownTable > </cfquery> > > I've never heard of any problems with CFQUERY before. I've never encountered > this problem with other CF ISPs. One of the people at our end is a top > flight CF programmer who's been doing CF forever and he's never heard of > this. > > Has anyone here ever run across this or similar before? Does anyone have > any insights or suggestions on the problem? > > Thanks; > > --- ed > > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "Edward J. Bebee" <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Mike" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
