Re: CF 7 ODBC server went stupid
Thanks guys! That will keep me from having to reboot the server at least (I hope). Interestingly enough it hasn't happened again since I sent out the email. --Ben On 10/25/2011 8:48 PM, .jonah wrote: If the ODBC service won't stop gracefully, you can kill the swstrtr.exe process via task manager. Depending on how you have your service recovery configured, it may automatically restart or you may have to go into services and restart it. On 10/25/11 8:20 PM, Kym Kovan wrote: On 26/10/2011 14:00, Ben Conner wrote: Hi, I host a number of sites, many of which use ODBC entries mainly to MS Access. In the last 30 hours ODBC connections stopped working. I've never even seen this happen before and was unable to gracefully stop the CF ODBC client/server services. Had to reboot the server to clear it out. Anyone seen this before, and/or even know which services I can kill and restart so I don't have to reboot the server? We are seeing a greatly increased level of SQL injection attacks for the last week or so, and using a new technique to get past some of the stoppers. Maybe your system locked up on handling something like that. (Insert standard statements about MS Access and sqlqueryparam here...) Chances are it was the database that hung so restarting CF won't help, a reboot is the best option. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF 7 ODBC server went stupid
Hi, I host a number of sites, many of which use ODBC entries mainly to MS Access. In the last 30 hours ODBC connections stopped working. I've never even seen this happen before and was unable to gracefully stop the CF ODBC client/server services. Had to reboot the server to clear it out. Anyone seen this before, and/or even know which services I can kill and restart so I don't have to reboot the server? Thanks! --Ben -- Ben Conner b...@webworldinc.com Web World, Inc. 888-206-6486 or PO Box 1122 480-704-2000 Queen Creek, AZ 85142 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348347 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 7 ODBC server went stupid
On 26/10/2011 14:00, Ben Conner wrote: Hi, I host a number of sites, many of which use ODBC entries mainly to MS Access. In the last 30 hours ODBC connections stopped working. I've never even seen this happen before and was unable to gracefully stop the CF ODBC client/server services. Had to reboot the server to clear it out. Anyone seen this before, and/or even know which services I can kill and restart so I don't have to reboot the server? We are seeing a greatly increased level of SQL injection attacks for the last week or so, and using a new technique to get past some of the stoppers. Maybe your system locked up on handling something like that. (Insert standard statements about MS Access and sqlqueryparam here...) Chances are it was the database that hung so restarting CF won't help, a reboot is the best option. -- Yours, Kym Kovan mbcomms.net.au ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 7 ODBC server went stupid
If the ODBC service won't stop gracefully, you can kill the swstrtr.exe process via task manager. Depending on how you have your service recovery configured, it may automatically restart or you may have to go into services and restart it. On 10/25/11 8:20 PM, Kym Kovan wrote: On 26/10/2011 14:00, Ben Conner wrote: Hi, I host a number of sites, many of which use ODBC entries mainly to MS Access. In the last 30 hours ODBC connections stopped working. I've never even seen this happen before and was unable to gracefully stop the CF ODBC client/server services. Had to reboot the server to clear it out. Anyone seen this before, and/or even know which services I can kill and restart so I don't have to reboot the server? We are seeing a greatly increased level of SQL injection attacks for the last week or so, and using a new technique to get past some of the stoppers. Maybe your system locked up on handling something like that. (Insert standard statements about MS Access and sqlqueryparam here...) Chances are it was the database that hung so restarting CF won't help, a reboot is the best option. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm