Postgresql connection?

5 posts, 0 answers
  1. Wenrong
    Wenrong avatar
    14 posts
    Member since:
    Sep 2011

    Posted 16 Feb 2012 Link to this post

    Does the designer support connection to postgres SQL server? Couldn't figure out a way to construct a working connection string...
  2. Iivari
    Iivari avatar
    4 posts
    Member since:
    Jun 2011

    Posted 17 Feb 2012 Link to this post

    I have problems with Firebird ODBC connection string. Firebird .Net connection string does not work any better.  Microsoft SQL Server works fine as always.
  3. DevCraft banner
  4. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 17 Feb 2012 Link to this post

    Hi guys,

    To connect to a PostgreSQL or FireBird database you will need .Net Framework Data Provider for PostgreSQL and FireBird. If you have installed such provider you can utilize our flexible SqlDataSource component. The SqlDataSource component uses ADO.NET classes to interact with any database supported by ADO.NET.

    All the best,
    Steve
    the Telerik team
    Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>
  5. Iivari
    Iivari avatar
    4 posts
    Member since:
    Jun 2011

    Posted 22 Feb 2012 Link to this post

    Hi,

    I still to struggle connect to Firebird database. I think my connection string is right because it works fine in Visual Studio editor. Here are my connection strings:
    Firebird .Net  provider
    character set=ISO8859_1;data source=127.0.0.1;initial catalog=Path to database file;user id=SYSDBA;password=password

    OBDC driver
    DSN=Firebird2;Driver=Firebird/InterBase(r) driver;Dbname=Path to database file;CHARSET=ISO8859_1;UID=SYSDBA;Client=C:\Program Files (x86)\Firebird\Firebird_2_1\bin\fbclient.dll;

    I just get "Unable to establish a connection to the database. Please, verify that your connection string is valid...."
    Can you please point out what is wrong in my connection strings.

    Br,
    Iivari Lampi

    Update: I needed to select provider name first. Now all good :) Maybe you should include provider name selection into new report wizard.
  6. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 22 Feb 2012 Link to this post

    Hello Iivari,

    Do you get this error at runtime only and you are able to preview the reports in Visual Studio? If so be aware that whenever the reports are defined in a class library, you use SqlDataSource component for your DataSource and you save the connectionString in the settings for this class library, always remember to copy the corresponding connection string entries from the class library's config file to the application's config file (in case of web application - web.config. Otherwise at runtime when the application's config file is respected the Settings object will not be able to find such connection strings and will return the default value from its metadata.

    Kind regards,
    Steve
    the Telerik team
    NEW in Q1'12: Telerik Report Designer (Beta) for ad-hoc report creation. Download as part of Telerik Reporting Q1 2012. For questions and feedback, use the new Telerik Report Designer Forum.
Back to Top
DevCraft banner