Cannot Add SQL Server 2005 Mobile to Pocket PC Project.

23 Mar 2006 2:59 PM

Dan Bass

-- Installed --
Visual Studio 2005 (.Net 2.0)
Sql Server 2005 Express
Sql Server 2005 Mobile SDK

I'm trying to add a "SQL Mobile Database" component to my Smart Device
project through Visual Studio 2005.

On one machine this works no problem (my laptop), but on my development
machine I get an error saying:
"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."

I've tried reinstalling the SDK with no change.

Any help would be appreciated.
Thanks,
Daniel.

23 Mar 2006 5:04 PM

Dan Bass

Reinstalled VS and it worked. Looking at the files between the system
that worked and the one that didn't, there were numerous SQL ce/mobile
files missing as well and registry inconsistencies.

VS 2005 Pro installs SQL Server 2005 support automatically. :-)

Dan Bass wrote:
Show quote

> -- Installed --
> Visual Studio 2005 (.Net 2.0)
> Sql Server 2005 Express
> Sql Server 2005 Mobile SDK
>
>
> I'm trying to add a "SQL Mobile Database" component to my Smart Device
> project through Visual Studio 2005.
>
> On one machine this works no problem (my laptop), but on my development
> machine I get an error saying:
> "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."
>
> I've tried reinstalling the SDK with no change.
>
> Any help would be appreciated.
> Thanks,
> Daniel.