If one exists, you should use a JDBC driver for the DB2 database. We have a JDBC driver for our AS400/DB2 and it has worked w/o any problems.
Also, who is to say that CF is at fault? I have seen the AS400/DB2 connection go down for many reasons, and they were never the fault of CF. Chances are that you switch to .Net and you could have the exact same problems. M!ke -----Original Message----- From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED] Sent: Friday, March 03, 2006 8:46 AM To: CF-Talk Subject: CF MX 7 and DB2 connection timeout We recently moved our web site to a CF MX7 box. Ever since we occasionally get the following error "Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=10054 - CWBCO1047 - The iSeries server application disconnected the connection" In the log files this is always preceded by the following error message ""Error","jrpp-1375","03/02/06","19:01:00","PSEA","Error Executing Database Query.Timed out trying to establish connection" This message happens 1-4 times and then the ODBC driver is unavailable until I restart the CF ODBC Server. Has anyone else experienced this scenario on CF and DB/2? Is there a way to automatically restart the ODBC server when this happens. Or is there another solution to resolve this issue? Even verifying the datasource in CF admin fixes it. It seems to be that CF stops trying if it gets the timeout message until the ODBC connection is refreshed? Any thoughts would be appreciated. Daron Smith PS I think my boss is thinking this is a good justification to go to ...Net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234083 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
