Pocket pc development

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.
I am new developer in the .net world, i have a project to implement a pocket
pc's application, it will be a smart client application, it will have its own
sql ce database and from time to time it will need to connect to a central
sql database server for database updates.
First of all, how can i connect the client application to the server?
Also, do i need a server application between the client and the database
server?
Thx for ur concern.
Philip.
 
You need to think about what sort of "updates" you're going to be having,
how much data is involved, and how often connections will occur. You might
want to set up a merge replication connection between SQL CE and the main
server, if the PPC program can *change* the data. If it can't change the
data, and you only want to update occasionally, you might want to just write
your code so that, when an update is triggered, it destroys the current SQL
CE database, connects to the server (there's just a different class for
remote data access, nothing fancy), and populates the local database. If
you're going to connect frequently for updates, maybe merge replication is
still the best thing. If you're always connected to the network, maybe you
don't need a local database at all and can just use remote data access to do
your lookups in the main server database.

Paul T.
 
Thx Paul.
But i still have a question, in the possible ways that u described, that is
a direct connection between the client and the database server, can multiple
clients access the server simultaniously or do i need a web service in
between to handle the incoming connections and to resolve conflicts?
 
"Multiple clients" needs more definition. SQL Server certainly supports
multiple clients at once, as you might imagine. Whether you can have
multiple programs on a single device running at the same time, I don't know.

Paul T.
 
Back
Top