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.

• Server
  

  The name of TNS alias of Oracle database to which to connect.

• User
  

  The Oracle login account. Leave blank if you want to use Integrated Security connections (OS authentication).

• Password
  

  The password for the Oracle login account. Leave blank if you want to use Integrated Security connections (OS authentication).

• Allow saving password
  

  If set to true password is stored among the other connection parameters.

  Caution:
  User password will be stored in your project in an unencrypted form (as plain text).

• Connect as
  

  Specify how you want to connect to server. This parameter can be Normal (default), SYSDBA, SYSOPER.

• Home
  

  Choose home to use. Not available in Direct mode.

• 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:

  1. Connect using TCP/IP protocol only.
  2. Some types are not available, like BINARY_DOUBLE, BINARY_FLOAT.
  3. Direct mode does not support NLS conversion on client side.
  4. RECORD parameters are not supported in Direct mode.
  5. Statement caching is not available.
  6. OS authentication and changing expired passwords features are not available.
  7. We don't guarantee dotConnect for Oracle compatibility in Direct mode with all Oracle servers and in every network. We have tested it with all versions of Oracle server for Windows and Linux since 7.3 in local network. Other platforms may cause some incompatibility issues.

  The Direct connection uses following specific parameters:

  • Host
    

    Oracle server's IP address or DNS name.

  • SID
    

    Name of listener service running on the server. The default value is empty string.

  • Port
    

    Number of a port to communicate with listener on the server. The default value is 1521.