Just an additional insight...
All I know is that it is not always easy to pinpoint
this kind of problem. A client of ours was running
CF against oracle. They could connect to oracle just
fine, but after 10 minutes, the CF Server would become
unresponsive. They also thought that it was CF or
even oracle, but found out that it was their firewall.
They did not suspect the firewall because things ran
fine for 10 minutes.
I am not saying that your situation is caused by the
firewall, but the environment can sure cause problems
that are hard to trouble shoot.
Is there any way that you can bypass the firewall in
order to rule it out?
I believe that it is somewhat rare that any CFers are
using a connection string to connect to sybase that
you may have a hard time finding help on this one.
Hopefully someone has an answer.
--- Todd Ashworth <[EMAIL PROTECTED]> wrote:
> | 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
