You could try putting a syslog on your firewall. That will tell you if it is
getting blocked. Also you could try running a packet sniffer on the DB or
webserver to verify the connectivity.
Steve
----- Original Message -----
From: "Suzanne Capener" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 10:37 AM
Subject: Re: Serious issues with connectstring causing CF server threads t o
hang
> 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
