How to check if "Create Database Connection" is successful?
Sep 4, 2019 12:33 PM(535 views)
Many of my scripts connect to a DB as soon as they are started. DB is in intranet, so users need to:
1. Be connected to internal network OR have VPN on
2. Have ODBC source set up correctly
Sometimes they don't.
I want to warn users that the DB is not available instead of script erroring on them. What would be a correct way of checking if "Create Database Connection" was successful and returned a valid handle?