Using the Microsoft ODBC Data Source Administrator

You can use the Microsoft ODBC Data Source Administrator to edit the DSN configuration. Note that the DSN is created during the installation process.

Complete the following steps to edit the DSN configuration:

1. Select Start > Search, and enter ODBC Data Sources in the Search box.
2. Choose the version of the ODBC Administrator that corresponds to the bitness of your application (32-bit or 64-bit).
3. Click the System DSN tab.
4. Select the system data source and click Configure.
5. Edit the information on the Connection tab and click OK.

Note: For .NET Framework 4.0, the driver distributes Microsoft Visual C++ 2015-2022 Redistributable. For .NET Framework 3.5, the driver distributes Microsoft Visual C++ 2008 Redistributable.

Ensuring Registry Access

The driver stores connection information in the Windows registry. To ensure that the driver can write to the registry, perform either of the following actions:

1. Run the calling application as an administrator.
2. Connect via a User DSN instead of a System DSN.

Connecting to Oracle OCI

Oracle OCI supports the following connection types:

• Oracle Server
• OracleTNS
• LDAP

Oracle Server

After you have added the appropriate libraries to your PATH (as described in Before You Connect), set these properties:

• User: The user Id provided for authentication with the Oracle database.
• Password: The password provided for authentication with the Oracle database.
• Port: The port used to connect to the server hosting the Oracle database.
• ServiceName: The service name of the Oracle database. You can obtain this value by querying global_name (select * from global_name) using the Oracle SQL*PLUS command line.
• Server: The host name or IP address of the server hosting the Oracle database.

OracleTNS

To authenticate via OracleTNS, set these properties:

• User: The user Id provided for authentication with the Oracle database.
• Password: The password provided for authentication with the Oracle database.
• DataSource: The connect descriptor (TNS connect string) or a connection name identifies the database you need to connect to. You can find these values in your tnsnames.ora file.

For example,

DataSource='(DESCRIPTION=(ADDRESS=(protocol_address_information))(CONNECT_DATA= (SERVICE_NAME=service_name)))'

LDAP

To authenticate via the LDAP server, set these properties.

• User: The user Id of a user account associated with the Oracle database.
• Password: The password associated with the specified user account.
• LDAPUri: The LDAP URI associated with the LDAP server you want to connect to.
• LDAPUser: The name of the user account on the specified LDAP server that you want to use to connect to Oracle OCI data.
  • Optional if your system administrator allows anonymous LDAP logins.
• LDAPPassword: The password associated with the specified LDAP user.
  • Optional if your system administrator allows anonymous LDAP logins.

Your connection string should look similar to this:

LDAPUri=ldap://myldap.com:389/SERVICE_EXMPL,cn=OracleContext,dc=example,dc=com; User=ORACLEUSER; Password=OracleUserPassword;