Good day
Can someone please tell me how to get a connectionstring to work with the Report Designer v 2.5.2
Provider=Microsoft.SqlServerCe.Client.3.5
It keep telling me provider not registered on local machine.
I created a sdf SQL Server Compact Edition Database and cannot get the connection string to work.
I even used code, still no luck
The connection string is currently set to:
.ConnectionString = "Provider=Microsoft.SqlServerCe.Client.3.5;Data Source=C:\Program Files\DCS\MyApp\Database\MyDatabaseXDB.sdf;Password=MyPassword;Persist Security Info=True"
.RecordSource =
Just cannot seem to get joy out of it.
The error:
The 'Microsoft.SqlServerCe.Client.3.5' provider is not registered on the local machine. Cannot open data source, please check ConnectionString and RecordSource properties
Are you having this issue only with report designer, or with your own apps created in Visual Studio as well?
A google search for "microsoft.sqlserverce.client.3.5 connection string" brought up quite a few hits some of which seem to describe problems similar to what you're seeing, in particular this thread suggests a couple solutions:
http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/ff731bf4-1f50-4f77-955b-e4534474a271
Let me know whether this helps.