How to connect to SQLite datasource?

[Chris]

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

 

[Stef]

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

[Chris]

Got it!

Thanks.

 

Chris