HOW TO SET UP ODBC
Back to current versionRestore this version

HOW TO SET UP ODBC#

The first step is to configure the ODBC Administrator.

The ODBC Administrator may be accessed through the Start menu, using the following path Start/Programs/Oracle 8I7/Network Administrator/MS ODBC Administrator

1. On the first screen, select the File DSN tab at the top of the screen (NOT User DSN or System DSN).

2. Once in the File DSN screen, click the Add button in order to add a new data source.

3. For our purposes, select Oracle ODBC Driver.
4. Click on the Finish button.

5. You will be then be prompted to select a name for the Access data source. In our example, we provided erosp as the name of the database from which we will access data.

6. Click the Next button. You are then presented with a summary of your choices.

7. Click the Finish button. You are then prompted to connect to the source database with the driver.

8. Click the OK button and the following screen will appear.