This is a migrated thread and some comments may be shown as answers.

How to connect to SQLite datasource?

2 Answers 122 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Chris
Top achievements
Rank 1
Chris asked on 15 Nov 2016, 11:18 AM

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 Answers, 1 is accepted

Sort by
0
Accepted
Stef
Telerik team
answered on 15 Nov 2016, 04:23 PM
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
0
Chris
Top achievements
Rank 1
answered on 15 Nov 2016, 05:26 PM

Got it!

Thanks.

 

Chris

Tags
Report Designer (standalone)
Asked by
Chris
Top achievements
Rank 1
Answers by
Stef
Telerik team
Chris
Top achievements
Rank 1
Share this question
or