Not sure why this happens. I have never found this issue before. Can you try to uninstall everything you have [SQL CE 3.5/4 and CEQuery] and try to install CEQuery for SQL Server 3.5 only from the link in this article? Make sure you have connected to Internet. Let me know if that solves the issue. Also, I have just uploaded a new installer today with sum bug fixes. The installer will be available in CodeProject in couple of days.
In the mean time, You can get the latest installer from the codeplex site. As you asked, I uninstalled CEQuery, SQLCE 4.0, SQLCE3.5 SP2. Then, as I use SQLCE 4.0, I installed SQLCE 4.0 and after I installed your last version of 'CEQuery v6 for SQL Server CE 4.0' downloaded today from codeplex. The error continues.
The SQL Server Data Mining team presents a set of prototype web services in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. Dangelo voodoo download blogspot. No installation required.
System.Data.SqlServerCe.SqlCeException: Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8482. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details. At System.Data.SqlServerCe.NativeMethods.LoadNativeBinaries() at System.Data.SqlServerCe.SqlCeConnection.ctor() at System.Data.SqlServerCe.SqlCeConnection.ctor(String connectionString) at CEQuery.OpenDB.btnOK_Click(Object sender, EventArgs e). According the KB article the exception asks to reference >> On 64-bit computers, a SQL Server Compact (“Compact”) based application may fail with one of the following two symptoms: Symptom 1 The application is trying to load a version of Compact that is incompatible with the version that is installed on the computer. Incorrect versions could lead to application instability and the loading of Compact would be aborted. Symptom 2 The application cannot load the native components of SQL Server Compact that corresponds to the ADO.NET provider.
Mayukh, I too was having the same problem as others. I believe the problem lies with the way you have referenced the SQLCE.dll's when trying to configure a private deployment. Teac owners manuals.
I solved the issue on my system by: -creating an app.config file (named CEQuery.exe.config) with the contents: -create a sub-folder in your install folder named 'SqlCe4' (matching the privatepath above) which contains System.Data.SqlServerCe.dll and the amd64 and x86 folders with sqlce*.dll files and Microsoft.VC90.CRT folder with required c++ file and manifest. -I removed your copy of the System.Data.SqlServerCe.dll file in the root of your install folder. Have a look at this for more info.