I have managed to get all report functionality working with a SQL Express database (in web application), but when I try to connect to a SQL Server Compact database, I get the following error:
An error has occurred while processing Report 'OutstandingPayments':
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 code behind the report designer is this:
Is there something I need to do to the connection string?
10 Answers, 1 is accepted
In order SQL Server Compact 4.0 to work properly you should have installed both the SQL Server Compact 4.0 and the SQL Server Compact 4.0 Visual Studio Tools. The tools are requiring Visual Studio 2010 SP1 to be installed.
All the best,
the Telerik team
i installed SQL Server Compact 4.0, SQL Server Compact 4.0 Visual Studio Tools.
but, still error message
Unable to find the requested .Net Framework Data Provider. It may not be installed
-report version 220.127.116.118
-design time good work
<?xml version="1.0" encoding="utf-8" ?>
For more information on how to configure your ASP.NET application, please visit
<compilation debug="true" targetFramework="4.0" />
<serviceHostingEnvironment aspNetCompatibilityEnabled="true" />
<dns value="localhost" />
<serviceMetadata httpGetEnabled="true" />
<serviceDebug includeExceptionDetailInFaults="false" />
how can i do?
the correct provider name should be as shown in the example below:
You could observe that when you made a SQL Server Compact connection in a ASP.NET application it will set this particular provider name.
All the best,
the Telerik team
When I use the connection string above, I receive: Unable to find the requested .Net Framework Data Provider. It may not be installed. If I use a connection string with a provider name of System.SqlServerCe.Client.4.0, I get an error saying SqlCeCommand.CommandTimeout does not support non-zero values. This sounds like a data related issue, but I am doing a simple select all query on a table with data in it.
I currently have a report working with a SQL Server Express database and would like to get it working with a SQL Compact 4.0 database.
As of the current version of Telerik Reporting the connection string:
is not valid, since there is no App_Data\Northwind.sdf in the examples.
About the "SqlCeCommand.CommandTimeout does not support non-zero values" on a 64-bit computer, you must run packages that connect to SQL Server Compact data sources in 32-bit mode. The SQL Server Compact provider that Integration Services uses to connect to SQL Server Compact data sources is available only in a 32-bit version. Please, check this http://msdn.microsoft.com/en-us/library/ms141253.aspx and see if the problem still persists.
Okay, I see that some connection manager is needed to communicate with the sql compact database, but I don't see how to implement the connection to the database.
I tried to install sql compact 32 bit, but quickly found out that the 32 bit can't be installed on a 64 bit machine. Can you help point me in the right direction?
It appears that the SQL CE 4.0 generic provider has a check whether CommandTimeout is always 0, and if not, throws the exception you posted. To workaround this problem try to manually set the CommandTimeout, ConnectionString, SelectCommand and ProviderName from the property grid of the SqlDataSource component i.e.:
I have a sql server compact edition 4.0 as data source and i need an example of the connection string.
My platform is windows 7 (x64) and visual studio 2010 sp1.
my path for the sql server database is:
I tried the following in the connection dialog box.
Data Source="C:\Users\asharma\AppData\Abc\TesterDatabase.sdf" (see attachment: telerik reporting database connection string)
but after clicking next when i try to build open query builder then i get error (see attachment: telerik reporting database error).
what are the things i need to add more in the connection string dialog box?
I would be nice if you could provide a proper example of the connection string as i am new to the database and reporting.
Take a look at http://www.connectionstrings.com/sql-server-compact/. It helped me get my conn string right.