In the
New Database Alias dialog, select
Relational Provider in the
Provider list.
Select
OLE DB in the Driver list.
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.
Select
Oracle provider for OLE DB
from the OLE DB Driver list.
Note: Do not use the Microsoft OLE DB Provider for Oracle.
Leave blank the
Database field.
Click the
Authentication tab.
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.