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)
