Do you mean the timeout setting in CF Admin or CF
query tag. The timeout in CF admin cannot time
certain requests out. CFHTTP is an example of that.
Did you set the timeout setting in settings for the
connection in your connection string. Also, there is
a timeout setting in the CFQUERY tag. Have you tried
that.
Just throwing out suggestions in hope to help.
--- Todd Ashworth <[EMAIL PROTECTED]> wrote:
> Yes, I wrapped a cftry/cfcatch specifficly around
> the query and set the page
> timeout to 15 seconds .. no good.
>
> Todd
>
> ----- Original Message -----
> From: "Johnson, Russell"
> <[EMAIL PROTECTED]>
> To: "CF-Server" <[EMAIL PROTECTED]>
> Sent: Thursday, July 26, 2001 4:04 PM
> Subject: RE: Serious issues with connectstring
> causing CF server threads t o
> hang
>
>
> > Are you using any type of error handling on the
> query attempts? This along
> > with the Timeout attribute can kill the thread if
> the request runs too
> long.
> >
> > Russ Johnson
> > Web Environment Services
> > Blue Cross Blue Shield of Florida
> > Work: 904-905-7130
> > Mobile: 904-534-8162
> > [EMAIL PROTECTED]
> >
> > "Great thinkers have always encountered violent
> opposition from mediocre
> > minds." -- Albert Einstein
> >
> >
> > -----Original Message-----
> > From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 25, 2001 10:59 PM
> > To: CF-Server
> > Subject: Serious issues with connectstring causing
> CF server threads to
> > hang
> >
> >
> > I have posed this question on CF-Talk and on the
> Forums and even opened a
> > ticket with Macromedia tech support, but I still
> don't have an answer.
> Tech
> > support is still working on a resolution (if there
> is one), but after 16
> > months of development, we are ready to deploy this
> app. for Beta testing
> and
> > this show-stopping problem is really throwing off
> our schedule. It is soo
> > frustrating to finish a long project only to be
> held up at the last moment
> > by a problem that can't be developed around! I'm
> hoping someone on the
> > cf-server list might have some ideas.
> >
> > Here we go ...
> >
> > I am using connectstring to connect to a Saybase
> database. I can normaly
> get
> > the queries to run fine, but if anything in the
> connectstring is wrong to
> > the point that it causes CF not to be able to
> connect to the database, the
> > current thread hangs 'permenantly'.
> >
> > This is a very serious problem for me because the
> application I am
> > developing *has* to use connectstring. There is no
> way around it, that I
> > know of. Also, end users will be providing some of
> the parameters that
> make
> > up the connect string, so the likelyhood of failed
> connection attempts is
> > _very_ high. This could eaily kill performance on
> the server enough to
> make
> > the program unusable within a very short time
> (seconds even).
> >
> > Here's my setup:
> >
> > CF Server is running on NT 4.0 SP 6 using IIS 4.
> > The database engine runs on Windows 2000 Pro SP 2.
> > The database is Sybase ASA 7.02
> > The 2 machines communicate via NetBIOS (the CF
> server has a public IP and
> > the database server has a private one)
> >
> > I pretty sure that the error has something to do
> with ColdFusion. The
> > database doesn't lock up in any way and actually
> returns an error message
> > saying that the database connection attempt
> failed. The CF machine
> actually
> > recieves the error because we can log it in the
> datasource log we set up.
> > ColdFusion is just missing this, or something.
> >
> > Here is the debug info from the datasource on the
> CF machine which
> includes
> > the connectstring (The invalid data in this
> connectstring is the password)
> > .. notice the CONN messages:
> >
> > -----
> > Wed Jul 18 2001 11:01
> > CONN: Application information:
> > "HOST=BUSINESSSAFE;OS=Windows NT 4.0 (Service Pack
> >
>
6);PID=0x5d;THREAD=0xc9;EXE=C:\CFUSION\bin\cfserver.exe;VERSION=7.0.2.1402;A
> > PI=ODBC"
> > CONN: Attempting to connect using:
> >
>
UID=3;PWD=******;DBF=e:\databases\gymtime\16.db;ENG=Saber;CON=SQL_DBC_4889cf
> >
>
8;ASTOP=YES;INT=NO;CBSIZE=4096;DBG=YES;LTO=10;LOG=c:\gymbob.log;DMRF=NO;LINK
> > S=netbios
> > NetBIOS -- Trying connection on lan adapter: 1
> > NetBIOS -- Looking for name on lan adapter: 1
> > NetBIOS -- Found name successfully on lan adapter:
> 1
> > NetBIOS -- Trying connection on lan adapter: 1
> > NetBIOS -- Found session connection on lan
> adapter: 1
> > CONN: Connected to the server
> > CONN: Database is running, but could not connect
> to it
> > -----
> >
> > So, as you can see, the CF machine is being
> notified that the connection
> > failed, it's just that CF doesn't seem to be
> getting the hint. The
> > connectstring is 100% correct, except for the
> password, which I inserted
> > incorrectly on purpose to generate the error. If
> the correct password is
> > provided, the connection is made and the query
> runs and the results are
> > returned .. everything performs perfectly.
> >
> > After further testing, I found that it does NOT
> have to be the
> connectstring
> > that is wrong. I moved the uid and pwd out of the
> connectstring and into
> the
> > username and password attributes of the <cfquery>
> tag. Now, if I provide
> the
> > wrong password, the connectstring is 100% correct,
> but I still get the
> hung
> > thread. This makes me think that anytime there is
> *any* type of database
> > error while using the connectstring attribute, I
> will get a hung thread. I
> > haven't tested this on access or SQL Server yet,
> though.
> >
> > I've included the query that I am calling.
> >
> > <cfquery name="qryValidateLogin"
> datasource="#Request.mainDSN#"
> > username="#qryGetUserID.contactPK#"
> password="#Attributes.txtPassword#"
> >
>
connectstring="dbf=e:\databases\gymtime\#Client.dbID#.db;eng=Saber;links=net
> > bios;">
> > SELECT 1
> > FROM dummy
> > </cfquery>
> >
> > I have tried using every "timeout" method
> available on all of the
> machines,
> > but the thread still hangs 'permenantly'.
> >
> > This is what I get in my application.log file, but
> I never get this error
> on
> > the screen:
> >
> > -----
> > Mozilla/4.0 (compatible; MSIE 6.0b; Windows NT
> 5.0; COM+ 1.0.2204), ODBC
> > Error Code = 08S01 (Communication link failure)
> [Sybase][ODBC
> > Driver][Adaptive Server Anywhere]Communication
> link failure: Communication
> > errorDate/Time: 07/18/01 10:59:53
>
=== message truncated ===
=====
Suzanne Capener
Macromedia Certified Instructor and Developer
INFOVISION INC.
Macromedia Premier Partner
http://www.infovisioninc.com
Toll Free: 877.727.8824
Cell: 801.391.9203
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
