Postgres Connection

2 posts, 0 answers
  1. Bernd
    Bernd avatar
    1 posts
    Member since:
    Mar 2018

    Posted 29 Mar Link to this post

     

    Hello,

    I try to connect to a prostgres Database with Report Designer.

    Connection is successful by connecting via odbc data source. But i fails when i`m using an connection string.

    I followed  this example:

    https://www.telerik.com/support/kb/reporting/accessing-and-managing-data/details/how-to-register-sqldatasource-data-providers-without-driver-installation

    I want to register the npgsql.dll directly in cofig file.

    Now, when i select SQL Data Source in Designer _> Build new Data connection -> Data provider (I can choose: Npgsql Data Provider) -> and type in connection string (Server=localhost; Port=5432; Database=DbName; User ID=demo; Password=demo;) 

    ERROR: Can not find registered .Net Framework-Data provider  

    Npgsql.dll and his dependencies are present in separate bin folder in AppRoot-folder.

    Any suggestions?

    Best regards,

    Bernd

     

     

     

  2. Silviya
    Admin
    Silviya avatar
    178 posts

    Posted 03 Apr Link to this post

    Hi Bernd,

    We provided the answers to your questions and the possible workarounds in the support ticket you opened for the same issue (ID #1160165).

    But since there is no sensitive information in your support thread, it is not an issue to share the original answer:

    "We tested locally to configure the Standalone Designer config file and everything seems to work as expected. However, we tested with version 3.2.1.0 of Npgsql.dll. We are not sure of the version that you are using, so please elaborate more or send us the designer's exe.config file to check and test once again.

    It would be necessary to register the Npgsql.dll assembly in the StandaloneDesigner config file with the corresponding version:
    <dependentAssembly>
            <assemblyIdentity name="Npgsql" version="3.2.1.0" culture="neutral" publicKeyToken="5d8b90d52f46fda7"/>
    </dependentAssembly>

    And also while registering the Npgsql.dll assembly:
    <add name="Npgsql" version="3.2.1.0" culture="neutral" publicKeyToken="5d8b90d52f46fda7"/>

    In case the used version is different and it causes errors, it might be because of the data provider for Postgresql Server's new update. Please revert to the stable one (3.2.1.0) to configure Npgsql for now."

    Regards,
    Silviya
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top