OLE DB

To create an Oracle OLE DB connection.

  1. In the New Database Alias dialog, select Relational Provider in the Provider list.
  2. Select OLE DB in the Driver list.
  3. In the Server field, enter the TNS name which is specified in tnsnames.ora.
    Note: The TNS name is the string immediately before =(Description in tnsnames.ora.

    Alternatively, you can enter the entire TNS definition from tnsnames.ora. That is, the string beginning (Description=.

    If you use the TNS definition, ensure that you remove all line breaks. For example, copy the description from tnsnames.ora into a text editor and edit it to create a single string.

  4. Select Oracle provider for OLE DB from the OLE DB Driver list.
    Note: Do not use the Microsoft OLE DB Provider for Oracle.
  5. Leave blank the Database field.
  6. Click the Authentication tab.
  7. Select Basic authentication and specify a valid user name and password for the database.
    The user name is the name of the owner of the Oracle tablespace to which you are connecting.