We are having trouble accessing MySQL 4.1 with CFMX. When we start using the connection (it is on a remote server) everything is fine for a few minutes and then CFMX starts crashing. (As crashing we'll see CF pages return with just a couple characters .< or something.)
We have followed all the prescribed set up for MySQL 4.1 but continue to see this problem on a production box. We don't have a problem on a development server pointing at the same MySQL db so it may have to do with load, but even on a small app we see the crashing start after a short while. Here are some error details: Event Viewer Entries: The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ColdFusion MX ODBC [EMAIL PROTECTED],ErrorCode=2310,ErrorMessage=TCP/IP, connection reset by peer. The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ColdFusion MX ODBC [EMAIL PROTECTED],ErrorCode=3059,ErrorMessage=The specified data source is not defined.,ClientHost=127.0.0.1,Session=219224. 01/28 12:01:42 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 01/28 12:01:46 info JRun Proxy Server listening on *:51010 01/28 12:01:46 info Deploying enterprise application "Macromedia ColdFusion MX" from: file:/D:/CFusionMX/ 01/28 12:01:47 info Deploying web application "ColdFusion Web Application" from: file:/D:/CFusionMX/ default-out.log: 01/28 12:01:40 warning Unable to open D:\CFusionMX\runtime/lib/license.properties 01/28 12:01:41 info JRun Naming Service listening on *:2901 01/28 12:01:42 info No JDBC data sources have been configured for this server (see jrun-resources.xml) Running on JRun4... Out of desperation we even tried the MyODBC connection but seem to be having trouble with that also. We are running on Windows 2003, CFMX all up to date, MySQL 4.1 on separate Windows 2000 server. Any suggestions appreciated. Luis >Could it be that you are using MySQL 4.1? > >http://www.talkingtree.com/blog/index.cfm?mode=alias&alias=MySQL41 >http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 > > >> The server and ports are correct. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192411 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
