DB Connection Timeout

[dsmith]

We use Client Access to connect to a DB/2 400 database.  However when the AS/400 is down for maintenance attempts to connect to that machine eventually lock up the CF server and I need to restart it.  I've tried a CFTRY, CATCH but the connection doesn't return an error it just hangs.  Is there a way to force the operation to quit if it isn't done in a specified amt of time?  I've tried using the CFQUERY timeout attribute, as well as the CF Admin DSN, the Client Access timeout settings to no avail.  Whenever the 400 is down (usually overnights, and weekends) our webserver crashes, so I need a way to not make the DB calls if the 400 is down.

Thanks for any ideas,
Daron Smith

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---