Testing the ODBC Connection
Make sure to test the ODBC connection to the Oracle database.
-
After setting up the connections to the Oracle database, click Test
Connection.
The Oracle ODBC Driver Connect dialog is displayed.
- (If applicable) Type your login information in the User Name and Password fields.
-
Click OK.
If the connection is successful, a message box indicating a successful connection is displayed. Otherwise, an error message is displayed advising you that the system is unable to connect.
If there is an error, resolve the problems indicated in the error message, for example, invalid user name.
- Click OK.