Can you try changing from ODBC to OLE DB? I have heard that it might make
things a little more stable. We used that method on one site and we are not
having any problems with it like what your describing below. There was an
article about it in the July issue of the CFDJ. Just a thought.
Bill
> -----Original Message-----
> From: Jimmy B. Glass [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 30, 2000 4:18 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: CF hangs
>
>
> Hey Guys...
> I am having the exact same problem as you guys have described...
> I have just
> taken over on this site, and it seems have been going on for a
> while. We are
> using CF 4.0.1 on NT 4 machines. We use SQL server as our DB. Did
> ya'll ever
> come up with a solution to the NT Errors 109 & 232? I tried your
> fix to tell
> the ODBC not to maintain a connection, but still am able to produce the
> "Unable to write reply - Client browser stopped waiting for
> request" which I
> feel triggers the NT Error 109, eventually halting CF server.
>
> Any suggestions would be greatly appreciated.
>
> Jimmy G
>
>
>
> ----- Original Message -----
> From: "Nille af Ekenstam" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, July 14, 2000 6:27 AM
> Subject: RE: CF hangs
>
>
> > Neil Robinson skrev:
> >
> >
> > >Hi Nille,
> > >
> > >I had what sounds like the same problem this week. What
> database are you
> > >using? If it's the same problem (check your server.log file for NT
> Errors)
> > >then it seems to be caused by ODBC drivers keeping database connections
> > >open. After the timeout period on the db server, CF tries to use the
> same
> > >connection pipe thinking that it's still open, and an error occurs. I
> > >disabled the 'maintain database connection' option on my oracle odbc
> driver
> > >and it's now been running fine for about 24 hours (normally it
> would hang
> > >after 1-2 hours).
> >
> > I'm using MSSQL7.0 as bd. Found a gazillion of these in my server.log:
> > "Error","TID=1448","07/13/00","23:15:58","Unable to write reply
> -- client
> > browser stopped waiting for request. "
> > "Error","TID=1448","07/13/00","23:15:58","Windows NT error number 109
> > occurred."
> >
> > Look familiar to you?
> >
> > I've just followed your advice on disabling "maintain db con" - hope it
> helps.
> >
> > Thanks Neil!
> >
> > file://Nille
> >
> >
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
