It appears that while the datasource is working, netstat returns an ESTABLISHED state for a connection both to and from the mysql database to cold fusion (and vice-versa).
Upon the datasource failing. I am returned only with a connection from mysql to CF in a state of TIME_WAIT for a little bit and then about 30 seconds later, no connections appear. So, it appears that the connection is closed after the timeout period, thereafter, the only way to re-connect is to re-add the datasource or re-verify the datasource. As for loggining in, I am using the same machine to log in with an X-Windows version of MyCC, using the exact same credentials with access to the same databases (same username and password), and the same mechanism would differ in that it is connecting through CF with JDBC instead of however MyCC connects directly. -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 7:35 PM One thing that jumps to mind is using netstat to check whether after the timeout period the open connection is really closed. > Also, I can login to mysql with simultaneous users using MyCC all while this > is going on, so I don't believe it to be a max users issue. From the same machine as CF MX? Using the same credentials? And the same mechanism? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
