I have installed SQL Server 2005 Compact Edition SP2 and the related SDK. I have added System.Data.SqlServerCe as a reference in my Windows mobile 6 Professional project. But every time I try creating a new data source using the data source wizard I get the following message: "unable to find the requested .Net Framework Data Provider. It may not be installed."
The connection tests fine but i cannot click OK and finish the data source setup because of this elusive error message. I have researched the Web and cannot find any solution.
I am using .Net Framework 2.0 and have installed SP2. I am developing on a Windows XP pro2 desktop.