For ColdFusion MX 7.x, have you tried upgrading the macromedia_drivers.jar to from the default v3.3 to v3.5? Does 3.4 make a difference?
See: Updated DataDirect JDBC drivers (version 3.5) http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=42dcb10a Also, if SQL Server database connections are returning "Connection reset", can you use netstat on the database to determine just how many open connections there are? I'm wondering if there are excessive open TCP connections on SQL Server. How many TCP connections are in ESTABLISHED, TIME_WAIT, or CLOSE_WAIT? How many of those are TCP connections to SQL Server? I'm wondering if the problem is simply that the database server has too many open TCP connections, whether they be for the database itself or the system overall. Review all TCP connections: netstat -an -p tcp Review only SQL Server connections: netstat -an -p tcp | find "1433" Also, the following bit of code will help determine which driver version you are using: <cfset drivernames = "macromedia.jdbc.oracle.OracleDriver, macromedia.jdbc.db2.DB2Driver, macromedia.jdbc.informix.InformixDriver, macromedia.jdbc.sequelink.SequeLinkDriver, macromedia.jdbc.sqlserver.SQLServerDriver, macromedia.jdbc.sybase.SybaseDriver"> <!--- replace all spaces ---> <cfset drivernames = replace(drivernames," ","","ALL")> <cfloop index="drivername" list="#drivernames#"> <cfobject action="CREATE" class="#trim(drivername)#" name="driver" type="JAVA"> <cfset args= ArrayNew(1)> <cfset driver.main(args)> </cfloop> <cftry> <cffile action="READ" file="#server.coldfusion.rootdir#/runtime/logs/coldfusion-out.log" variable="log"> <cfset log = listtoarray(log,chr(10))> <cfloop from="#(arraylen(log)-5)#" to="#arraylen(log)#" index="i"> <cfoutput>#log[i]#</cfoutput><br/> </cfloop> <cfcatch>Look in {cf_root}/runtime/logs/{server}-out.log for results of driver version info</cfcatch> </cftry> -Steve ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
