put a database in the \databases folder

put a database in the \databases folder

Post by John S » Tue, 30 Sep 2003 13:48:25

I am trying to create a database via c#. I have successfully created a
.sdf file in my program folder and I am quickly learning the
System.Data.SqlServerCe tree. However, when I "explore" my active sync
connection I find a special folder "\Databases" with the outlook, et al.
databases in it. These databases seem more secure, in that they are not
able to be copied to the computer, only sync'd. Whereas, the .sdf file
can be copied to the PC. I do not want my database to be able to be copied
manually over to the PC. How can I get a database like the outlook ones
that can't be manually coppied? What do I need to look up how to do this?
What is the difference?


put a database in the \databases folder

Post by Peter Foot » Tue, 30 Sep 2003 17:24:22

Databases is not a real folder in the file system. This is a "virtual"
folder used for ActiveSync to show you the database tables which exist in
the ObjectStore. These are CEDB tables (aka Pocket Access) and you cannot
place any other types of database here such as SqlServerCE.


Peter Foot
Windows Embedded MVP
www.inthehand.com | www.opennetcf.org