This topic describes connection parameters for the dotConnect for Oracle data provider.
Server
The TNS alias of the database server to which connection should be established. This field is not available if the Direct option is selected.
Home
Choose Oracle home name to be used. This field is not available if the Direct option is selected.
Direct
Enabling this option allows you to establish direct connection to your Oracle server, without calling any third party libraries and without requiring Oracle Client software. If this option is enabled, the Server and Home fields are not available.
SID
Specifies the System identifier (Global Database Name). This field is available if the Direct option is selected.
Port
Specifies the port the server listens to. The default value is 1521. This field is available if the Direct option is selected.
User Id
Specifies the user name used to connect to your Oracle database.
Password
The password for the Oracle login account.
Allow saving password
If set to True, the password is stored together with the other connection parameters.
|
User password will be stored in your model in an unencrypted form (as plain text). |
Connect as
Specify how you want to connect to the server. This parameter can be set to Normal (default), SYSDBA, SYSOPER.
