How to connect to SQLite datasource?

3 posts, 1 answers
  1. Chris
    Chris avatar
    2 posts
    Member since:
    Nov 2016

    Posted 15 Nov 2016 Link to this post

    We are evaluating the Telerik reporting products and one requirement is that the stand-along designer must be able to connect directly to a SQLite database.

    Not knowing whether the report designer is only compatible with a particular version of SQLite , we have installed various versions of it but cannot find any option within the designer to allow us to connect to the database. Searching the forum we found a post for a similar request dated back in 2012 that suggested changing the exe 'config' file but that did not appear to work in our case.

    Any help would be greatly appreciated.

     

    Chris

     

  2. Answer
    Stef
    Admin
    Stef avatar
    3610 posts

    Posted 15 Nov 2016 Link to this post

    Hi Chris,

    Please check the Data provider is missing in the SqlDataSource wizard KB article, and verify the data provider is installed and registered properly on the machine, and that the application target platform is considered with the version of the installed .NET connector (x86 or x64 version).

    Then start a report wizard and the SqlDatasource Wizard. At the end verify that the SqlDataSource.ProviderName is set to the SQL Lite .NET data provider. It is recommended to have the providerName attribute set in the connection string (the one in the configuration file).

    Regards,
    Stef
    Telerik by Progress
    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
  3. Chris
    Chris avatar
    2 posts
    Member since:
    Nov 2016

    Posted 15 Nov 2016 in reply to Stef Link to this post

    Got it!

    Thanks.

     

    Chris

Back to Top