Accessing sdf files on VS2003

Greetings!

The company I'm working for has an ASP.NET system made using Visual Studio 2003 and the 1.1 Framework. Now we need a Pocket PC application to work with a subset of the main app's database. There is already a Microsoft Access file that does the same work which this PPC app must do, and we have in the ASP.NET system an import functionality that takes the generated .mdb file and extracts all the information.

What I need is a way to extract from .sdf files the information that we currently obtain from .mdb ones. I searched around the web and it seems that the namespace needed for this is the "System.Data.SqlServerCe.dll" (or something to that effect), but I can't find the references to add to our project under Visual Studio 2003.

What do I have to install to make this work Or if anyone would be even kinder, would there be a smarter way to manage this importing business

Thanks in advance.

Answer this question

Accessing sdf files on VS2003

ErikL2007
you maybe able to do it in VS2003 (.NET 1.1) depending on the device platform (if its a PPC) using an earlier version of SQL CE I believe which maybe obtained from perhaps the same site but a different location
_Matt Smith _
So, there is no way to do this with Visual Studio 2003 It's said on the SQL Mobile download page that the 2005 version is required, but I wanted to read the .sdf file under a project that was created with VS2003. Is this possible

By the way, sorry for posting in the wrong section.
ackermsb

in order to use SQL CE you need to download and install SQL Server mobile edition from Microsoft's website, and add the reference in your project:

http://www.microsoft.com/sql/editions/sqlmobile/default.mspx

I will also move this thread to the .NET CF forum as I believe it would be best suited there since the query is regarding SQL Server CE and PPC
Accessing sdf files on VS2003

Answer this question