Using SSL with dotConnect for PostgreSQL from NuGet

Using SSL with dotConnect for PostgreSQL from NuGet

When using dotConnect for PostgreSQL via NuGet packages, note that SSL support is not included in the NuGet assemblies by default.

To enable SSL connections, you must manually add the necessary assemblies from the full Devart installation package to your project:

  

 

After adding the required libraries, configure the connection using the appropriate ConnectionString parameters. See the official documentation for details:
 
Key SSL-related connection string parameters:


SSL CA Cert

The location of the authority SSL certificate.
Ssl Cert
The location of the client SSL certificate.
Ssl Cipher List
The list of ciphers that client agrees to use.
Ssl Key
The location of the user's private key.
Ssl Mode
SSL connection priority. May be Disable, Allow, Prefer, and Require. The default value is Disable, which means that only an unencrypted SSL connection will be attempted.
SSL TLS Protocol
Specifies the maximal TLS version to report to the server when establishing a connection. Supported values are "1.0", "1.1", and "1.2". The default value is "1.1".

 

For more advanced configuration, refer to the SslOptions property:
    • Related Articles

    • dotConnect for Oracle distribution

      dotConnect for Oracle is distributed in two ways: - As the installer that provides assemblies for Full .NET Framework, documentation, samples, and all the necessary files. - As NuGet packages with .NET Standard compatible assemblies for .NET Core. ...
    • Password visible in Connection string ODBC PostgreSQL

      When connecting to a PostgreSQL database using ODBC, you may encounter a situation where the password is visible in the connection string in Microsoft Excel. Unfortunately, we do not have the ability to alter how Excel handles or displays this ...
    • TLS 1.3 Support on Windows 10 with MySQL and PostgreSQL

      Issue When connecting to MySQL or PostgreSQL servers on Windows 10, you may encounter errors if the server is configured to use only TLS 1.3. However, the connection succeeds if TLS 1.2 and TLS 1.3 are both enabled. Reason Windows 10 does not support ...
    • Unable to Connect Using macOS DSN Configuration

      If you’ve installed an ODBC driver on macOS but can’t proceed with setting up a DSN because the iODBC Data Source Administrator app is missing, here’s how to resolve the issue. Step 1: Install iODBC Manager To test and manage ODBC connections on ...
    • How to Connect Using ODBC in Crystal Reports

      Crystal Reports allows users to build custom reports by connecting to various data sources. To connect using an ODBC driver, follow these steps: Step 1: Create a Crystal Reports Application Launch Crystal Reports and create a new report. Select a ...