SQL Server CE Reference

[info]

Hi There

In my Application I want a conenction to the SQL Server CE. I've read
some guides and How to's but it won't work.

First of all I can't add the reference to the SQL CE Database beaucse
I've no entry of System.Data.SqlServerCe.

What should I do to get the reference ?
I've Installed the SQL Server CE on PC and Pocket PC

thank you

 

[Darren Shaffer]

You may have to "browse" to the SqlServerCe assembly to add the reference:

If you're in Visual Studio 2003 add a project reference to:

C:\Program Files\Microsoft Visual Studio .NET
2003\CompactFrameworkSDK\v1.0.5000\Windows CE\System.Data.SqlServerCe.dll

If you're in Visual Studio 2005, add a project reference to:

C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL
Server\Mobile\v3.0\System.Data.SqlServerCe.dll

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

 

[Ashkan]

Connecting PDA to network!

Hi there,

I am developing a PDA application will use SQLCE to collect/cache some data on the pda and then these data should be synchronized with the SQL server. In my project, I cannot use WiFi. What is the best way to connect the pda to the server and sync data? Can I connect pda to a client machine by using USB port and connect my pda to the server/network through ActiveSync? If so, How?

Or, is it better to connect the PDA directly to the network by using Ethernet Cradle?

Thanks,
Ashkan
(e-mail address removed)