I have created a WPF application that uses SQL CE 4.0 database and runs fine, however, when I try to view a report that uses the same database I get the below error
An error has occurred while processing Report 'RacerAverages':
Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.
------------- InnerException -------------
Unable to find the requested .Net Framework Data Provider. It may not be installed.
The report works fine in the VS 2010 environment and all data is shown but not when deployed or run in debug mode. All CE .dlls are copied to the Debug folder?
Is there something special I am missing? Below is my config settings...
An error has occurred while processing Report 'RacerAverages':
Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.
------------- InnerException -------------
Unable to find the requested .Net Framework Data Provider. It may not be installed.
The report works fine in the VS 2010 environment and all data is shown but not when deployed or run in debug mode. All CE .dlls are copied to the Debug folder?
Is there something special I am missing? Below is my config settings...
<add name="RacingApp.Properties.Settings.RacerAveragesSQL" connectionString="Data Source=C:\data\RacingAppData.sdf" providerName="Microsoft.SqlServerCe.Client.4.0" /> I have the SQL 4.0 CE and VS 2010 Tools installed. I have seen this Thread, which seems to be similar but have done everything mentioned with no resolution? Please help, this has been a thorn in my side for weeks now... thanks, SD.
3 Answers, 1 is accepted
0
Hi Steve,
In the forum thread you've referenced, my colleague provides the correct providerName that should be used for SQL CE: providerName="System.SqlServerCe.Client.4.0".
Greetings,
Steve
the Telerik team
In the forum thread you've referenced, my colleague provides the correct providerName that should be used for SQL CE: providerName="System.SqlServerCe.Client.4.0".
Greetings,
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.
0
Steve
Top achievements
Rank 1
Rank 1
answered on 04 Apr 2012, 11:06 PM
Thanks for your reply Steve...
I changed my providerName to "System.SqlServerCe.Client.4.0 "
instead of "Microsoft.SqlServerCe.Client.4.0"
and still get the same error? The original value "Microsoft.SqlServerCe.Client.4.0" was added by Telerik when my report was created and works fine with this setting in VS when "Previewing" the Report. However when I use the System.SqlServerCe it will not load my report data in VS or running stand alone?
Any ideas?
I changed my providerName to "System.SqlServerCe.Client.4.0 "
instead of "Microsoft.SqlServerCe.Client.4.0"
and still get the same error? The original value "Microsoft.SqlServerCe.Client.4.0" was added by Telerik when my report was created and works fine with this setting in VS when "Previewing" the Report. However when I use the System.SqlServerCe it will not load my report data in VS or running stand alone?
Any ideas?
0
Hello Steve,
The SqlDataSource component uses a Visual Studio service that provides the wizard and query builder in order to connect to a data base. In this line of thoughts, it is not the Telerik Reporting product that adds the providerName, but Visual Studio itself.
Researching on this generic SQL error you've hit, which does not occur on our end, we've found the following threads which might help you:
Greetings,
Steve
the Telerik team
The SqlDataSource component uses a Visual Studio service that provides the wizard and query builder in order to connect to a data base. In this line of thoughts, it is not the Telerik Reporting product that adds the providerName, but Visual Studio itself.
Researching on this generic SQL error you've hit, which does not occur on our end, we've found the following threads which might help you:
- Unable to find the requested .Net Framework Data Provider. It may not be installed
- StackOverflow: Unable to find the requested .Net Framework Data Provider
As by default VS does not provide SQL CE 4.0 provider, make sure you have installed it manually:
Greetings,
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.