Hey yo, I'm setting up a new service and thought I'd start with Access databases for the first few sites while I designed a better back-end SQL Server Express management application, and am having a problem.
At the beginning of this new venture I had to reboot the server once a week when suddenly CF server couldn't create a db connection. As time went on it had to be done more frequently, to the point of having to do it twice today. I thought I could get by until I finished the SQL Server version, but now I can't ignore it any longer. Originally I had set up the connections in CF Server to "maintain connections" with the standard 20 / 7 min timeouts. 1000 max on the server, but I think maybe CF Server isn't destroying the connections? Just now, for testers, I went through all the dsns and unchecked the maintain connections checkbox to see if the problem persists. Any thoughts? Have I mis-configed something important? Seems pretty standard. Is there something I can use to view all open DB connections, and what process hasn't closed the connection? Perhaps it's my code somewhere. I'm just not sure where to start on this one. I'm on a VPS running Windows 2003 Server and using Access 2000 databases. -------- Michael Muller Muller Technologies 24 3rd Street Turners Falls, MA 01376 work: (413) 863-0030 cell: (413) 320-5336 skype: michaelBmuller http://support.MullerTech.com Eschew Obfuscation ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
