[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8080

Posted on 2014-08-21
8
Medium Priority
?
3,361 Views
Last Modified: 2014-08-22
I am getting the following error on my PC when debugging a new app:

'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.'

I followed the advice of the error and referred to the article at http://support.microsoft.com/kb/974247

I can confirm that I have both the 32-bit and 64-bit installed.

My App is in VB.Net 2008 and is a desktop app. Within it I am creating a utility that will create an sdf to be loaded to a Windows Mobile 6 Pro Device. The same app does work on the device but will not work on the PC version and I do not know why.

I even tried the advice given in this article http://www.dotnetfunda.com/forums/show/2868/unable-to-load-the-native-components-of-sql-server-compact-correspondi but that does not work either.

Any ideas of what is going on?

Thanks
0
Comment
Question by:PBLack
  • 5
  • 3
8 Comments
 

Author Comment

by:PBLack
ID: 40277626
Some more info on this. I changed the SQL refernce to version 4 and it works fine. Unfortunately Windows Mobile 6 Devices do not support version 4.

I do not want end users making setup files on the device as the person who makes the setup files wants to have more control over the process. He wants to make setup files for a job and then distribute them by email to the field agents who will then upload it and collect data within the mobile app the references the sdf created on the PC.

I'm at a loss how to do this.
0
 
LVL 84

Accepted Solution

by:
David Johnson, CD, MVP earned 2000 total points
ID: 40277930
remove all references to sql compact on your computer, reboot, install SQL Server Compact 3.5 SP2 x86 only, compile your application for x86 and not anycpu
0
 

Author Comment

by:PBLack
ID: 40277985
Thank you very much. That did the trick. It did break my OpenNETCF reference but I just dropped it and added it back it and then magic.

You just made the subscription worth.

A good end to a frustrating day.

One thing before I go....

I do have another project coming up in using VS 2013 and SQL Server Compact 4. Will installing it again break what I have?

Thanks
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

Author Closing Comment

by:PBLack
ID: 40277987
Worked like a charm.
0
 
LVL 84

Expert Comment

by:David Johnson, CD, MVP
ID: 40277994
yes it it will break it again
0
 

Author Comment

by:PBLack
ID: 40278639
Time to buy  a new computer.
0
 
LVL 84

Expert Comment

by:David Johnson, CD, MVP
ID: 40278759
virtual machines can be a great assist sometimes.
0
 

Author Comment

by:PBLack
ID: 40278988
OK Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Integration Management Part 2
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question