Friday, June 14, 2013

SQL server compact edition : "The application is trying to load native components of version 5386 that are incompatible with ADO.NET provider of version 8080." error

Cause:
This error occurs when SQL server compact edition 3.5 is upgraded to SP2.

Altough the 3.5 SP2 files are installed on the desktop, the files deployed on the CE devices are still the old ones.

Solution:
After upgrade Goto Path: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\armv4i
copy Cabs:
1. sqlce.ppc.wce5.armv4i.CAB
2. sqlce.repl.ppc.wce5.armv4i.CAB
3. sqlce.dev.ENU.ppc.wce5.armv4i.CAB
to your device and install them. This will replace the SQL CE 3.5  with 3.5 SP2

Reason for the err:
Installing SQL CE 3.5 will install 3.5.0.0 version of System.Data.SqlServerCe.dll whereas 3.5 SP2 will install 3.5.1.0 version of System.Data.SqlServerCe.dll

2 comments:

h said...

You saved my day - and perhaps my life.
For Windwos CE I copied
sqlce.wce5.armv4i.CAB, sqlce.repl.wce5.armv4i.CAB and sqlce.dev.ENU.wce5.armv4i.CAB.

The exception disappeared!

1000 thanks.

Anonymous said...

Thanks for info