SQL CE Binding

[Darren]

I'm trying to connect to a SQL CE database to run a report.  Not trying to design it or anything.

When I connect to a normal database it works but when I connect to:

Data Source=c:\UserProfiles\admin\Datasets\DEMODATASET2011.sdf;Persist Security Info=True;

I get an error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

The CE database is working fine otherwise.

Does my connect string need to be different?

Thanks,
Darren

[Elian]

Hi Darren,

If you do not specify a provider name, by default it tries to connect to SQL Server. In your case, you have to specify the provider name (and you need to have the provider installed).

A sample connection string in the config file would look like this:

<add name="Name"

            connectionString="Data Source="c:\users\...""

            providerName="System.Data.VistaDB" />

--this is for VistaDB yours would be different probably something like "System.Data.SqlServerCe.SqlCeConnection"


Some references that might help you:

• Connection strings for SQL CE
• SqlDataSource component - here 
  
  

All the best,
Elian
the Telerik team

[CEFRA]

I have de same problem, but i think that SQL CE is not suported by Telerik Reporting. My problen is when i try tu create a new report and i chose my connection and this fail, then i create a new connection and all is fine. Test my connection and is fine but when i try to creeate my Query in the wizard show me the same error other error is illegal characters.

[Darren]

Yes Carlos, you have to upgrade to CE 4.0.