Re: ODBC Server Error
heath stein wrote: We are running into a problem with our server, that is running Coldfusion MX7 . Its seems every 12 to 24 hours the server stops serving pages. It seems to be that the Coldfusion MX7 ODBC Server some how chokes, and then wont respond. Don't use ODBC, use a JDBC Type 4 driver. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ODBC Server Error
http://jtds.sourceforge.net/ -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, May 04, 2007 9:02 AM To: CF-Talk Subject: Re: ODBC Server Error heath stein wrote: We are running into a problem with our server, that is running Coldfusion MX7 . Its seems every 12 to 24 hours the server stops serving pages. It seems to be that the Coldfusion MX7 ODBC Server some how chokes, and then wont respond. Don't use ODBC, use a JDBC Type 4 driver. Jochem ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ODBC Server Error
What's in that query? Rob -Original Message- From: heath stein [mailto:[EMAIL PROTECTED] Sent: 04 May 2007 13:52 To: CF-Talk Subject: ODBC Server Error We are running into a problem with our server, that is running Coldfusion MX7 . Its seems every 12 to 24 hours the server stops serving pages. It seems to be that the Coldfusion MX7 ODBC Server some how chokes, and then wont respond. When I log on to the server and try to restart Coldfusion, I am able to stop all Coldfusion service but the MX7 ODBC Server. The only way I have been able to get Coldfusion running again is to restart the server. Also Jrun is all the way up to 250,000 k when the this problem is occurring. ERROR LOG Error,jrpp-1,05/04/07,05:38:41,TheLight,The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: D:\website\the_light_com\html\The_light\Board.cfm, line: 3 coldfusion.runtime.RequestTimedOutException: The request has exceeded the allowable time limit Tag: CFQUERY Any help would be greatly appreciated. Thanks Heath ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ODBC Server Error
Thanks I think I have found the problem. It turns out that a query on one of our site was access a session variable as the data source. The session variable did not have a lock around it. Thanks ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
