Sorry. The Endoscopy server has to
be re-booted as it has become unresponsive (can't even be ping-ed) Once
the Endoscopy server is responsive, then CF works again.
CF is on a different server but has to
link to the Endoscopy server to get results.
-----Original
Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 07 April 2004 11:56
To:
[EMAIL PROTECTED]
Subject: Re: [ cf-dev ] CF ODBC to
unresponsive SQLServer, and fine-tuning ODBC data-sour ces
you said that rebooting the
server causes CF server to stop running - are the CF services set to
Automatic?
Duncan Cumming
IT
Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel:
0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical
world
----------------------------------------------------------------------
Get
your domain names online
from:
http://www.alienationdomains.co.uk
Reseller options
available!
----------------------------------------------------------------------
----------------------------------------------------------------------
|
|
"Osullivan
Karl (RKB) Senior Analyst/Programmer"
<[EMAIL PROTECTED]>
07/04/2004
11:50
Please respond to
dev |
To: CF - Development Group
<[EMAIL PROTECTED]>
cc:
Subject: [ cf-dev ] CF ODBC to
unresponsive SQLServer, and fine-tuning ODBC data-sour
ces |
I'm having problems
with my CF server in that it keeps hanging - not processing any CF pages at
all. However, the Task Manager reports an Idle CPU of 98%.
I have narrowed the problem down
to another server that I retrieve patient endoscopy results from, stored in
SQLServer7. Sometimes this server becomes completely unresponsive and
has to be re-booted, and somehow this in turn causes my CF server to stop
processing .cfm pages. I know this is an on-going problem, so I put some
error trapping in my program, such that:
<CFSET
db_endoscopy_error = false>
<CFTRY>
<!--- Get the list of reports for the patient --->
<CFQUERY NAME="Get_Pt_Endo" DATASOURCE="#Request.DSN#">
SELECT ReportNo,
VersionNo
FROM
Reports
WHERE
Patient = '#URL.id#'
</CFQUERY>
<CFCATCH TYPE="Database">
<CFSET db_endoscopy_error = true>
</CFCATCH>
</CFTRY>
<CFIF
db_endoscopy_error>
Sorry, database is
down
<CFELSE>
Show the
results
</CFIF>
This seems to work if SQL
Server is STOPPED on the server, but does NOT work if the whole Endoscopy
server is unavailable. Is there something else I should be checking for?
I thought, based on the CF ODBC settings below, it would try, fail after
5 seconds, and then report an error.
The settings I have in CF5 for
Endoscopy are:
Login timeout: 5
does this mean
timeout if can't login in 5 seconds?
Limit connections: not
ticked
Maintain database connections:
ticked
Connection timeout: 20
minutes
I'm also a bit unsure as to
whether these settings are optimum. Basically, the server only get's
about 100 queries a day, and each only ever returns 1 or 2 records. So
any advice on ODBC setup in CF would be appreciated.
Thanks
Karl O'Sullivan
