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