Unchecking the 'Maintain Database Connnections' check box seems to have fixed the problem. Our AS/400 was unavailable for a significant time this w/e for an offline backup. In the past this would have definitely killed the datasource. But Monday morning everything was OK.
>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:234481 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