Andy What would you like to do if you can't connect to the database? What version of cf and how many apps on the server?
Just a suggestion if you're using cfmx7 - You could use the admin api to disable datasources to prevent any other applications trying to connect to the server, it would result in all your applications throwing more errors - (if you're happy for this to happen as long as cf stays up then it may not be much of a problem assumming you have some error handling in place) you could then run some code which continually attempts to connect to the database (as well as notifying you *once* by email that it cant connect) once it connects it could then re-enable the datasources. Just a suggestion, haven't tried it myself Kola > -----Original Message----- > From: Andy Jarrett [mailto:[EMAIL PROTECTED] > Sent: 05 October 2005 12:05 > To: CF-Talk > Subject: MSSQL and CF connections > > Hi > > I am currently running a MSSQL sever in a DMZ setup with an externally > hosted website. The problem is due to a driver error the DMZ has been > rebooting recently and when it does the CF box comes down with it > (just the CF services). > > The problem i think is down to ColdFusion coldfusion not being about > to connect to the SQL server. When this happends it is getting > overloaded with conenctions waiting for a response bring CF down. > > Has anyone else been in this situation, how have you resolved it? > > I've looked at the "Limit Connections" and "Timeout (min)" under > datasources and was wondering what would be a good optimal for these > in this situation? > > Many thanks, Andy > > www.andyjarrett.co.uk > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220116 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
