It sounds like a problem with the mySQL ODBC driver. You could try switching to the JDBC driver and see if it helps.
Or, failing that. Stop using MySQL and try PostgreSQL if you want a GPL (free) database. Or, switch to Sybase or MS-SQL is you can. Byron -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Melanie Maddix Sent: Wednesday, May 29, 2002 2:29 PM To: [EMAIL PROTECTED] Subject: [CFTALKTor] MySQL Error Hi there, I have a question about an error we are getting on our pages with queries the first time they are loaded each day. I've pasted the error below. If we refresh the page or go to it again after that, we do not get the error. The only information I can find is that MySQL closes connections after 8 hours of inactivity. The place that is hosting the site doesn't seem to have an answer. Does anyone know what this is, or what sort of error handling we could do to get around it? Thanks for your help, Melanie Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S1000 (General error) [TCX][MyODBC]Lost connection to MySQL server during query - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Melanie Maddix" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] (Byron Bignell) To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
