I still haven't been able to get the host to resolve this problem, and I've decided to just abandon MySQL for SQL Server. The database is simple and I can make the change quickly.
To wrap this up, based on what I've learned and what my web research shows: . The problem exists only for MySQL with ColdFusion running under Windows . If you turn off Maintain Connections across client connections in the advanced datasource settings, the problem goes away. Obviously this would impact server performance and isn't a fix. . So, it is sort of a communications problem. It seems that between ColdFusion and the MySQL driver the reference to the database connection gets confused. ColdFusion expects the connection to the database, but doesn't find it and throws the error. . Maybe there's a set of ColdFusion/MySQL/Server configuration settings that will fix this. Or, maybe it's a ColdFusion or MySQL bug. I just don't know. Anyway, thanks for all the great ideas. At least I learned some new tricks! Clarke -----Original Message----- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 5:13 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I got another piece of data from using the cfdbinfo tag. Sometimes, it throws this error: So, I think you're right Wes. It is some kind of communication problem. If this new data gives anyone any ideas on where to go next, please let me know. Thanks again for all the help! Clarke ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
