The ODBC timeouts are part of settings for configuring the DSNs in CF Administrator. There's controls for limiting the number of simultaneous connections as well as the timeout values of each of those connections. In a transition-controlled environment, you'll definitely want to limit the number of connections as well.
Ron -----Original Message----- From: Cameron [mailto:[EMAIL PROTECTED]] Sent: Monday, November 05, 2001 1:50 PM To: CF-Server Subject: SOT: Database, ODBC connection timeout settings... Hi All, A project I am doing involves requiring the setting of connection timeouts for a transaction server. I need to be able to set and control the connection timeout settings for SQL Server 2000, ODBC to the database, and HTTP to the transaction file. Setting the HTTP timeout is easy. What I can't find is how to set the ODBC connection timeout or the SQL Server 2000 timeout. I need to have the DB timeout less than the ODBC timeout which is less than the HTTP timeout so the transaction server and frontend know's where the timeout is occuring. Can't have the ODBC connection go down while the database is still updating something... So, anyone able to help me? Cameron ---------------------------------------------------------------------------- -- To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
