PocketPC Development - Database quesitons.

  • Thread starter Thread starter Shawn & Jo-an Mehaffie
  • Start date Start date
S

Shawn & Jo-an Mehaffie

I just got a ViewSonic V37 and want to create some programs using VS.Net 2003 for PocketPC's. Below are a few questions I hsve:

1) What databased does the compact framework support without installing any other software. From what I've found it looks like I can use XML and Access without installing any other software. To support SQL Server what would I need to install on the PocketPC and how much space does it take?

2) No matter what database I use, how can I tell my application to install the database on my flash disk and then access the database from that drive? If I buy a memory card can I install the application and database all on the same memory card?

3) Is it easier to sync an Access or SQL Server database. or do you have to write the code to sync the databases manually?

S. Shawn Mehaffie.

P.S. If anyone has any suggestions on good books on this subject please let me know.
 
1) What databased does the compact framework support without installing
any other software. From what I've found it looks like I
can use XML and Access without installing any other software. To support
Click to expand...
SQL Server what would I need to install on the
PocketPC and how much space does it take?
Click to expand...

PocketPCs support the use of Compact Access, but to access the Compact
Access you would need something like http://www.inthehand.com 's
PocketAccess wrapper component. They also have one to access CeDbs.

SQL Server CE is a light-weight version of SQL Server for PocketPC, but must
be installed onto the device, however .NET CF has full support, without need
for 3rd party components, to access to the SQL Server CE database. As for
space, think its around a couple meg (i.e.1 or 2 meg, not precisely sure).
2) No matter what database I use, how can I tell my application to install
Click to expand...
the database on my flash disk and then access the
database from that drive? If I buy a memory card can I install the
Click to expand...
application and database all on the same memory card?

Where the PocketPC OS installed SQL Server CE I don't think you have a
choice, but you can create a SQL Server CE db anywhere you want through the
create command.
3) Is it easier to sync an Access or SQL Server database. or do you have
Click to expand...
to write the code to sync the databases manually?

Think its easier to sync Access because the ActiveSync will create a Compact
Access database when transfering down, and *may* convert back on the way up
to PC. SQL Server CE can sync with a SQL Server database. THere is native
support in PocketPC to sync to the database through two methods, mentioned
heavily in the newsgroup, but requires that IIS be installed on the machine
being synched to.
 
I just use a comma seperated text file, but my databases are simple. The RegEx make it easy to import/export data.
 
1) What is the licensing for SQLCE? Can I distribute it with my
applicaitons?

2) Can you use REgEx to read-write XML files?

Thanks,
S. Shawn Mehaffie
 
Back
Top