Testing DSN's before processing queries

[dsmith]

Does anyone know a method to test a DSN before running a query?  We link to an AS/400 DSN which is occasionally offline for backups, maintenance, etc.  I'd like to run a test that if the DSN isn't working will display a "Please come back later" message.   Any suggestions?

Thanks,
Daron Smith

---

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

---