All: In case anyone was curious, I believe I've discovered the source of this problem. Apparently, at the same time the web host switched DB drivers, they also began recycling one of the ODBC services every hour. The recycling appears to have been the culprit. Ever since they stopped recycling the service (this morning), I have yet to receive another notification of this problem (and I was receiving several each hour).
So there you go. Thanks for the help. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ Mosh Teitelbaum wrote: > I was recently called in to troubleshoot a site that has been showing all > kinds of problems. One problem that just recently began showing > up includes > the following error message: > > "Error Executing Database Query. [Macromedia][SequeLink JDBC Driver] > Connection closed due to session kill." > > I've searched Google, HOF and Macromedia livedocs and forums without much > luck. The only thing even remotely useful I could find suggests that the > error message is coming from the SequeLink driver ( > http://media.datadirect.com/download/docs/slnk/errmsgs/codes.html -- do a > search for "session kill"). > > Has anyone seen this before? Any idea what could be causing it > and what can > be done to fix it? > > The site is running on CFMX/SQL Server 2000 on Windows. The DB connection > was going through the JDBC-ODBC bridge but was recently switched over to > ODBC Sockets. These errors began around the same time as that switch but, > for various reasons, the host is not willing to switch back. > > The files and line numbers indicated in the error messages > suggest that this > problem happens whether the code uses CFQUERY or CFSTOREDPROC. > > Any help would be greatly appreciated. > > TIA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208251 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
