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 PostgreSQL data provider.

• Host
  

  Name or IP address of host of PostgreSQL database.

• Port
  

  The port of PostgreSQL database to which to connect. The default value is 5432.

• User ID
  

  The name of the user to connect.

• Password
  

  The user's password.

• 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).

• Database
  

  The name of the database. If this parameter is not specified, it is assumed that name of the database is same as user name.

• Schema
  

  PostgreSQL schema to use.

Note:
Click the Advanced button to set up specific parameters of SSL connection. The list of these parameters is described below:

• SSL Mode
  

  This option determines whether an SSL connection will be established the server and its priority.

• SSL Cipher List
  

  List of cheepers that client agrees to use.

• SSL CA Cert
  

  Location of authority certificate.

• SSL Cert
  

  Location of client certificate.

• SSL Key
  

  Location of user's private key.