Unfortunately I don't have any solutions for you Will, other than to tell you that we had experienced the exact same behavior on our servers here. Our admins got tired of rebooting (the only way to fix the problem, as you stated). We've since moved all of our connections over to JDBC (dunno if that's an option in your case?), and have not had the problem since. (Also, when things do get out of wack, you can write a little script to reset the connection without a reboot).
On 8/4/06, William Bowen <[EMAIL PROTECTED]> wrote: > > > Ahhhh, the life of a cf programmer/security guy/server guy. > > All, > > I had a CFMX (6.1 with all patches/updaters) server lose its ODBC > connection the other night. Four minor load sites that have been > humming along on their new very happy home (Dell 1850/Dual Xeon Dual > Core procs/Windows Server 2003 with all updates) for six months. > > It was really bizarre. Other servers (development boxes) connecting to > the same DB were good to go, so I ruled out a SQL Server 200 issue. I > could connect to the remote DBs through the ODBC control panel on the > server itself, logged in through RDS. > > JRun was running at 150MB which is not unusual so I tried cycling the > 3 CFMX Services which had no effect. > > I finally restarted the box which alieviated the problem, but I'm at a > loss as to what caused it or what might be the solution. > > Any ideas? > > > -- > will > > "If my life weren't funny, it would just be true; > and that would just be unacceptable." > - Carrie Fisher > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:212513 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
