Have you ever tried testing an ODBC Data Source for connectivity to an Oracle RDBMS? You create your System DSN from within the ODBC Data Source Administrator, but how do you know if you have a valid connection or not?
One tool that you could use is the Microsoft Data Link API. This API allows you to quickly test for ODBC connectivity without having to download additional files. This can come in handy when trying to determine if your ODBC Data Source is configured correctly. Here's what you need to do to use this tool for testing ODBC connectivity.
How to Use
If you would like to know more about the Microsoft Data Link API tool, select the Data Link Properties "Help" button for additional information.