You can translate the question and the replies:

Access Through an ADO.NET Data Provider - Supported NPGSQL versions

Dear Denodo Team, actually we are using NPGSQL version 2.2.7 to connect to VDP server, as recommended by you, but after disabling TLS versions 1.0/1 at our environments, these drivers are not working anymore. At following page Denodo recommends to use 2.0.12, 2.2.0, 2.2.3 and 2.2.7, but these should not be used anymore ( as described under tje donwload repository). The version 3.x of NPGSQL is supported partially. https://community.denodo.com/docs/html/browse/latest/en/vdp/developer/access_through_an_ado.net_data_provider/access_through_an_ado.net_data_provider Due to this we want to ask you which NPGSQL driver versions are supported and recommended from your side? Regards, Gerhard
ADO.NET npgsql
user
09-11-2023 03:44:37 -0500
code

3 Answers

Hi, In general, Virtual DataPort is compatible with the .Net Data Provider for PostgreSQL version 2.0. The recommended versions are 2.0.12, 2.2.0, 2.2.3 and 2.2.7. Also the version 3.x of NPGSQL is supported partially. Here, I understand that you are facing the issue after disabling the TLS versions 1.0/1 at your environments. Hence, could you please elaborate the issue you are facing, so that we can analyze this situation further (i.e. what is the error message you are getting, where you have disabled the 1.0/1 TLS version?). Also, as a test could you please try connecting the Virtual DataPort server via Web Design Studio, Data Catalog, Virtual DataPort Admin Tool and let us know if you are able to connect without any issues. This helps us isolate the issue further. Finally, if your Denodo Platform is SSL enabled, please check that you have added the ["SSL=True;Sslmode=Require"](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/access_through_an_ado.net_data_provider/access_through_an_ado.net_data_provider#:~:text=If%20SSL/TLS,the%20ConnectionString.) parameter in the connection string. If you have disabled the SSL, then kindly remove the above mentioned parameter in the connection String and try the connection once again. Further, if you have a valid support access, then you could also raise a new support case where we could assist you more regarding this issue. Hope this helps!
Denodo Team
16-11-2023 08:59:14 -0500
code
Dear Denodo Team, SSL is enabled at all Denodo components since we introduced it. The only issue we are facing after disabling 1.0/1 TLS within our company is the access via NPGSQL driver 2.2.7. In meanwhile we switched to dirver 3.x to overcome the issue. We also have other (new) NPGSQL driver versions in place, to use one of them we have to know if they are (fully) supported from Denodo side or not. On opening the download link (https://github.com/npgsql/npgsql/releases/tag/v2.2.7) provided at page (https://community.denodo.com/docs/html/browse/latest/en/vdp/developer/access_through_an_ado.net_data_provider/access_through_an_ado.net_data_provider) it's defined, that they recommend to only use 3.x or higher, because at 2.x.x only critical bugs are fixed and nothing more. So could you please check and adapt the article (link before) with all supported nqgsql driver versions. Thanks. Regards, Gerhard
user
17-11-2023 03:11:59 -0500
Hi, I understand that you have new NPGSQL driver versions for utilization. Also, as per [NPGSQL](https://github.com/npgsql/npgsql/releases/tag/v2.2.7), it is suggested to upgrade to NPGSQL 3.x and higher. But as of now, we have officially tested the compatibility of the Virtual DataPort only with NPGSQL 2.0.12, 2.2.0, 2.2.3 and 2.2.7 versions and the version 3.x of NPGSQL is supported partially. To avail, have a track of the full support of version 3.x and higher, I suggest you to create a new case of type “Request (Enhancement Request)” in the [Support site](https://support.denodo.com/) (if you have valid support access) as we already have an existing enhancement to address this feature separately. Hope this helps!
Denodo Team
20-11-2023 06:29:56 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here