Connection options

Devart ODBC Driver for Oracle provides multiple connection options to ensure flexibility, security, and integration with various applications and environments. Connection options for the driver depend on the chosen connection mode: Direct or Oracle Call Interface (OCI).

Direct mode connection

The Direct mode connects directly to the Oracle database without requiring Oracle client software.

To enable this mode, select Direct.

The Devart ODBC Driver for Oracle Configuration window with the selected Direct option and completed fields

Required parameters:

Host – The host name of the server hosting your Oracle database.

Port – The port number for the connection. The default port is 1521.

Service Name – The service name of your Oracle database.

User ID – The Oracle username.

Password – The Oracle password.

Connect Mode – The system privilege level (or “mode”) used by the user when connecting to the server. The default mode is Normal. The required privilege must be granted to the user beforehand.

Sample connection string:

DRIVER={Devart ODBC Driver for Oracle};Direct=True;Host=myServer;Service Name=myServiceName;User ID=myUsername;Password=myPassword

OCI mode connection

The OCI mode relies on Oracle client software installed and configured on the system.

The Devart ODBC Driver for Oracle Configuration window with completed fields

Required parameters:

Home Name – The identifier of the Oracle client installation to use.

Server – The host name or IP address of the Oracle server.

User ID – The Oracle username.

Password – The Oracle password.

Connect Mode – The system privilege level (or “mode”) used by the user when connecting to the server. The default mode is Normal. The required privilege must be granted to the user beforehand.

Sample connection string:

DRIVER={Devart ODBC Driver for Oracle};Data Source=myServer;Home Name=myHomeName;User ID=myUsername;Password=myPassword