I use a website with mysql database and ODBC connections and sometimes, about once every month one of my connections will get lost causing me to have to contact the hosts technical support to reset the connection/fix the issue. This is an annoyance and ok for now but we are redesigning our site and turning away from the static html pages for our product section to a database driven solution but I don't want to run into this issue which would cause the website to not work until I can contact the host, get them to reset the connection, etc....
One option I though of is possibly doing a cftry and catch using 2 different odbc connections for the queries like <cftry> query 1 odbc 1 <cfcatch> query 1 odbc 2 email myself to contact host tech support </cftry> While not the most advantageous it should prevent data interuptions and give me some lead time to correct issues with the odbc connection 1. My host has said this has to do with me "closing my odbc connections" however I have never run into this and talked to several other people who have said that that's crazy. Any thoughts? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4770 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
