OK, Over the last 6 months we have been running pretty extensive metrics on the way ColdFusion and SQL Server behaves when a long running SQL Server process runs (commonly with a Stored Procedure actioned by cfstoredproc). Now, we know and have seen that a long running process in SQL Server may have a few exclusive locks when updating / inserting but we also know that the SQL Server is happily performing and serving data during this time for other tables/sites etc so we are not too worried about them at present. However if, after a variable amount of time CF doesnt get any more info or data from SQL Server - the CF Server will just crash without fail - it's like clockwork and usually the only way to get it to recover is a reboot of the server.
We haven't tried or looked at any other drivers other than the vanilla 3.3 Drivers which ship with CFMX 6.1 SP1 so I am not sure if the drivers are the problem as they are not legacy drivers what with 3.4 being released by DataDirect. Any ideas? Windows 2000 IIS 5.x (with IIS Lockdown) SQL Server 2000 SP3a ColdFusion 6,1,0,hf56991_611 Enterprise DataDirect 3.3 JDBC Type 4 Thanks N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189339 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