We are updating an application of wince 6 with sql 3.0 to wince7 with sql 3.5 and it gives errors when opening the database. We have tried to execute the example that is in your page “How to use SQL Database in VCSharp” and it gives us the same error.
Message = “Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8080. Install the correct version of SQL Server Compact.” Refer to KB article 974247 for more details. "
HResult = -1
NativeError = -1
Source = “”
at System.Data.SqlServerCe.NativeMethods.LoadValidLibrary (String modulePath, Int32 moduleVersion)
at System.Data.SqlServerCe.NativeMethods.LoadNativeBinaries ()
at System.Data.SqlServerCe.SqlCeConnection…ctor ()
at System.Data.SqlServerCe.SqlCeConnection…ctor (String connectionString)
at sql_demo.Form1…ctor ()
at sql_demo.Program.Main ()
We believe that it is a problem of SQL versions. What version is installed with the .cab that comes in “toradex_sql_compact_v3_5.zip” ?.
Or what version of sql server compact should we install in VS2008?
The version we have now is sql server compact 3.5 SP2.