Connection parameters are specific for the data provider you have chosen. In dependence of selected DBMS it is necessary to use different parameters, based on the selected DBMS specific. These parameters are used for the connection string generation. This topic describes connection parameters for dotConnect for Oracle data provider.
The name of TNS alias of Oracle database to which to connect.
The Oracle login account. Leave blank if you want to use Integrated Security connections (OS authentication).
The password for the Oracle login account. Leave blank if you want to use Integrated Security connections (OS authentication).
If set to true password is stored among the other connection parameters.
![]() |
---|
User password will be stored in your project in an unencrypted form (as plain text). |
Specify how you want to connect to server. This parameter can be Normal (default), SYSDBA, SYSOPER.
Choose home to use. Not available in Direct mode.
Direct mode is an option allowing you to connect to the database directly without pre-installed Oracle client.
Please note, that the Direct mode has some limitations:
The Direct connection uses following specific parameters:
Oracle server's IP address or DNS name.
Name of listener service running on the server. The default value is empty string.
Number of a port to communicate with listener on the server. The default value is 1521.