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

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
PBLackAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PBLackAuthor Commented:
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
David Johnson, CD, MVPOwnerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PBLackAuthor Commented:
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

PBLackAuthor Commented:
Worked like a charm.
0
David Johnson, CD, MVPOwnerCommented:
yes it it will break it again
0
PBLackAuthor Commented:
Time to buy  a new computer.
0
David Johnson, CD, MVPOwnerCommented:
virtual machines can be a great assist sometimes.
0
PBLackAuthor Commented:
OK Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.