Hi Kola, First of we are running CFMX 7 on a fairly busy (dedicated) server.
I did think about checking running some scheduled code to check if the server is there, but im more concerned if the MSSQL services are actually running. I don't want to connect to the Datasource as that "seems" to be were we are getting the hang ups. I suppose if could ping the server and port see if its there first actually without using the datasource. Cheers, Andy On 10/5/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220185 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
