A couple of questions regarding connection timeout settings for a MS SQL 2K obdc data source: While trying to run a backup job on the db, the job said that it was unable to go into single-user mode because of the cf connection. This was without any activity on the site, and profiler shows that the CF account was maintaining the connection. After checking the data source settings in cf administrator, I noticed that the connection timeout was set to 0 minutes for several of the data sources. So, would having the connection timeout set to 0 cause CF to maintain the connection indefinitely? What is the recommended setting for connection timeout? This is a low-to-medium traffic intranet site. Also, this is for a CF5 server. Are the recommended settings different for CF MX? Thanks, Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
