Also why not just use 2 nic cards on the webserver. That way you can have
your live IP on one nic and then on your other nic you can set it to the
same subnet as the DB.
----- 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
