We are using connectstring to connect to an ODBC database. It works fine
unless the connectstring that gets passed has incorrect data in it. If that
happens, the connection just hangs and doesn't time out .. at least not for
a long time. Once we get 5 of these in a row, it's bye-bye CF server until
the service is restarted. This is driving me crazy. I can't figure out why
this is happening. Does anyone know exactly how CF and the connectstring
and the database interract? Is there a way to force either CF or the
database to throw an error instead of just locking a process and sitting
there forever? Here's what I get in my log file:
2001-07-13
15:40:54
Information
538
The ColdFusion Application Server started.
2001-07-13
15:40:48
Error
438
ExprParser: CFuncIsDefined::DoIt: unknown
2001-07-13
15:40:48
Fatal
438
Unknown error threshold reached. Restarting service.
2001-07-13
15:40:28
Error
479
!! CFTrace::logThread(113) has no entry for thread 113
2001-07-13
15:40:28
Warning
479
A request exceeded the timeout. The unresponsive thread count is up to 1.
[C:\Inetpub\wwwroot\gymtime_2\index.cfm]
2001-07-13
15:40:18
Error
438
Unable to write reply -- client browser stopped waiting for request.
2001-07-13
15:40:18
Error
438
Windows NT error number 109 occurred.
2001-07-13
15:40:18
Error
438
Error number 232 occurred attempting to close connection to web server.
2001-07-13
15:40:18
Warning
438
Template: C:\Inetpub\wwwroot\index.cfm, Ran: 19 seconds.
2001-07-13
15:40:18
Error
438
Windows NT error number 232 occurred.
2001-07-13
15:37:29
Warning
113
Template: C:\Inetpub\wwwroot\index.cfm, Ran: 24 seconds.
2001-07-13
15:37:08
Error
245
Unable to write reply -- client browser stopped waiting for request.
2001-07-13
15:37:08
Error
245
Windows NT error number 109 occurred.
2001-07-13
15:37:08
Error
245
Error number 232 occurred attempting to close connection to web server.
2001-07-13
15:37:08
Warning
245
Template: C:\Inetpub\wwwroot\index.cfm, Ran: 27 seconds.
2001-07-13
15:37:08
Error
245
Windows NT error number 232 occurred.
2001-07-13
15:33:27
Information
443
The ColdFusion Application Server started.
Based on that, I can't really tell which service is causing the problem, the
database or CF. The database engine doesn't seem to be affected by any of
this, so I'm thinking it's something to do with CF.
I'm running CF 5 on NT 4.0 Service pack 6 with IIS 4
The database is Sybase ASA 7.03 running on Win2k Pro Service pack 2
The 2 machines communicate over NetBIOS
My connectstring looks like this
"uid=username;pwd=password;dbf=e:\path\to\database\databasefile.db;eng=dbeng
inename;links=netbios;astop=true;astart=false;"
The connectstring works fine as long as there is nothing wrong with it.
But, even if something as simple as the username or password is wrong, it
causes a thread to hang.
Help?
Todd
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
