User`s guide

Oracle ODBC for Windows

2-45

Step 2. Verify the driver installation.

The ODBC driver is typically preinstalled on your computer. For details about the driver

installation or troubleshooting the installation, contact your database administrator

or refer to your database documentation on ODBC drivers. For information about the

Microsoft ODBC Data Source Administrator, see Driver Installation.

Step 3. Set up the data source using the ODBC Data Source

Administrator.

Set up an ODBC data source using the ODBC Data Source Administrator for Oracle

with or without Windows authentication. Database Explorer cannot work with the

Oracle ODBC driver because of an issue with the JDBC/ODBC bridge. For details, see

“Database Explorer Error Messages” on page 3-14.

Click Start. Select Administrative Tools > Data Sources (ODBC) to define the

ODBC data source. The ODBC Data Source Administrator dialog box opens. For

details about locating this program on your computer, see Driver Installation.

Click the System DSN tab and then click Add. When setting up an ODBC data

source, you can use a User DSN or System DSN. A User DSN is specific to the user