Eric Harmon

Hi, I'm looking into programming smart devices and I want to create a SQL Server CE database in my app. I created a device application and added two text boxes to it just as a test. It runs fine.

When I Add New Item and select Database file and click OK, I get the following error message:

The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed DataSet associated with the file will not be generated.

Do I need to install something else on my computer (like SQL Server CE If so, is 3.1 the latest version I thought I installed that last night and it didn't have any effect, but I tried so many things that I'm not positive now. Is there anything else I need to install as well I installed the Mobile 6 Professional SDK last night as well.



Re: Smart Devices General Getting started with device programming - can't create database

BadgerB

You should be able to install SQL Server CE 3.1 SDK and things should work.

I'm using datasets extensively and they seem to be working well.

Bob





Re: Smart Devices General Getting started with device programming - can't create database

Eric Harmon

OK, I didn't have the SDK installed - just the CE runtime. So I just downloaded and installed the SDK. Unfortunately, I have the exact same issue after installing the SDK :-(

-Eric





Re: Smart Devices General Getting started with device programming - can't create database

Zero Dai - MSFT

Dear Eric,

In my opinion, this is the issue on your Visual Studio IDE.

Actually, you don't need to install Sql Server CE, since it is included when you install Visual Studio 2005 (When you install Visual Studio 2005, it appears as Sql Server Mobile Edition. And, it will be upgraded to Sql Server Compact Edition when Service Pach 1 is installed). You can find it under the folder "C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0", if your Visual Studio is installed correctly.

According to the error information you attach here, you can create the database file, but IDE will not create dataset.xsd file for you. That is the root cause. So, it is recommended to repair your Visual Studio. Thanks!

Regards,

Zero Dai - MSFT






Re: Smart Devices General Getting started with device programming - can't create database

Eric Harmon

Zero,

OK, I'll do that tomorrow and let you know if I still have an issue with it. I'll do a repair, then reinstall SP1, then reinstall SP1 for Vista.

-Eric





Re: Smart Devices General Getting started with device programming - can't create database

Eric Harmon

Zero,

I'm running now. I repaired VS2005, then reinstalled SP1 and then the Vista SP. I then noticed that my desktop shortcut for some reason wasn't set to run as administrator, so I changed it. One of those two things fixed it, because now I'm running fine.

Thanks!

-Eric