ADO.NET and PocketPC

  • Thread starter Thread starter MikeH
  • Start date Start date
M

MikeH

I need to write an app that runs on a Pocket PC and
updates a SQL Server database on a local network via
wireless.

The updates need to be in real time and therefore I want
to update the DB directly rather than by some batch
method.

If the RDBMS only allows Integrated Security, how can I
log on to SQL Server from the Pocket PC?

Thank you
 
I can think of two directions to head.

1. Find a way to have the Pocket PC user log into the network. I am not
certain how that can be accomplished, as i have never used a Pocket PC on a
network.

2. Do all data CRUD through a web service. It will slow things down a bit, a
bit more with ASMX than remoting, but it will relieve having to have the
user "logged in" in a traditional manner. You will have to create some form
of authentication on the service, however, to stop non-users from CRUDing
the database if a Pocket PC is stolen. The benefit of ASMX is you will not
have to install .NET on the Pocket PC (which might not be a problem); any
component that can send SOAP via HTTP will work. On the backside, you will
have to authenticate (mentioned) and impersonate a valid account after
authentication.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
Back
Top