| Can you connect to a Acces DB / SQL DB from the one machine to the other ?
I haven't tried. We don't use Access or SQL server. We can connect to
Sybase just fine, except under 1 speciffic circumstance.
| This way youll figure out if this is a network or application level
problem.
I think it's a server level bug.
| Is there a firewall between the two ?
Yes, kind of, but I really doubt this is the problem.
| With the limited info I have,
| to me it seems as if some of the return packets are dropped somewhere.
But why does it ONLY happen if there is an error that prevents a connection
to the database (i.e. bad username or password). If it was a network
problem, I would think that I wouldn't be able to connect to the database at
all. Again, I can ALWAYS connect to the database and get whatever
information I want from it, or whatever error message is generated, as long
as all of the connection parameters are right. If any of them are wrong,
then instead of CF telling me that the connection failed, it hangs, BUT ONLY
if I'm using the connectstring parameter. If I don't use connectstring, I
get a connection failed error message, like normal. This has to be a bug in
5.0
For more information about this problem, see the post that started this
thread .. I practicly wrote a book explaining the problem in great detail,
including connectstrings, log file entries, and sample queries.
Thanks for all of the suggestions so far.
Todd
----- Original Message -----
From: "Herman Cremer" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 9:28 AM
Subject: RE: Serious issues with connectstring causing CF server threads t o
hang
|
|
|
| -----Original Message-----
| From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
| Sent: Saturday, July 28, 2001 7:51 PM
| To: CF-Server
| Subject: Re: Serious issues with connectstring causing CF server threads
| t o hang
|
|
| Yes .. I have tried every timeout setting I can think of / find. None of
| them work.
|
| Todd
|
| ----- Original Message -----
| From: "Suzanne Capener" <[EMAIL PROTECTED]>
| To: "CF-Server" <[EMAIL PROTECTED]>
| Sent: Saturday, July 28, 2001 1:24 PM
| Subject: Re: Serious issues with connectstring causing CF server threads t
o
| hang
|
|
| > 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.
| >
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
