Data Provider for SQL Server Compact

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leila - 17 Sep 2007 20:42 GMT

Hi,
In VS.NET, from the Data menu I try to add a new connection to *.sdf file,
but I don't have any Data Source for SQL Server Compact Edition when I click
"Change" button.
I installed the following file:

C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\sqlce30setupen.msi

but nothing appeared.
Any help would be greatly appreciated.
Leila

Reply to this Message

Erik Ejlskov - 18 Sep 2007 17:27 GMT

You must be using Visual Studio 2005 Standard or higher and have the "Smart
Device Programmability" option selected during install.

For a longer version, see:

http://blogs.msdn.com/stevelasker/archive/2007/08/07/configuring-visual-studio-2
005-for-use-wtih-sql-server-2005-compact-edition.aspx

Signature

Erik Ejlskov Jensen
- see my SQL Compact blog at
http://erikej.blogspot.com

> Hi,
> In VS.NET, from the Data menu I try to add a new connection to *.sdf file,
[quoted text clipped - 8 lines]
> Any help would be greatly appreciated.
> Leila

Reply to this Message