Creating an Oracle ODBC connection

To create an Oracle ODBC connection:

  1. Create a system DSN, using the Microsoft ODBC for Oracle driver. Specify the TNS name from tnsnames.ora as the Server name. The user name is the name of the owner of the Oracle tablespace to which you are connecting.
  2. In the New Database Alias dialog, select Relational Provider from the Provider list.
  3. Select ODBC from the Driver list.
  4. Select the DSN from the DSN list.
  5. Click the Authentication tab and select Basic in the Authentication list.
  6. Specify the user name and password.
Parent topic: Creating a database alias