Re: Database app for xda II

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 05/20/04


Date: Thu, 20 May 2004 11:41:46 -0400

Hi John:

No, this isn't a problem per se. However, you don't want to use Access
here, MSDE is free and it's a lot easier to use and supports both RDA and
Merge Replication.. We have a whole SQL Server CE section here
http://www.devbuzz.com/content/init_sqlce_starting_out.asp and Rob Tiffany
(who wrote the only book on Pocket Access and eVB as well as a new Book on
Sql Server CE w/ the compact framework
http://www.devbuzz.com/content/init_sqlce_starting_out.asp) is one of our
forum Moderators. Anyway, if you REALLY want to use access, Peter Foot
wrote a wrapper for it (ADOCE) available at www.inthehand.com which is a
wonderful product. It's very well priced and I know many many people who've
used it and the feedback is always the same - Excellent.

If you have GPRS access though, you can hit the SQL Server directly as long
as you want to expose it to the net (which you may not want to do). For
this, Web Services could easily fill in the gap and they are guite easy to
implement. Casey and www.brains-n-brawn.com has done a ton of work with
data transfers over web services and he's got some great articles which are
quite complex but his discussion makes them clear as day.)

Anyway, you can use BlueTooth, 802.11 xxx , the cradle to access a network.
Once you have access you can use ActiveSync, Simple file moving, Web
Services, the SQL Client library, Merge Replication, RDA etc to get the data
around.

Head over to www.devbuzz.com like I mention above for we have some great
resources. We've got pretty strong MVP support and the authors of just
about every CF related book is either a moderator or a regular visitor.

Also, www.opennetcf.org is the BEST CF content site on the web, there's tons
of examples, an extensive (open source) libraray and a whole host of
Embedded and Compact Framework MVP's to assist you with anything you may
need.

-- 
W.G. Ryan, eMVP
http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
"John" <john@nospam.infovis.co.uk> wrote in message
news:ewrV$mmPEHA.3216@TK2MSFTNGP12.phx.gbl...
> Hi
>
> We have a .net database app with MS Access backend running in house over a
> windows 2000 server network. Is it possible to re-write the same app for
xda
> ii (http://www.xda-2.co.uk/under_the_bonnet.html) /windows mobile 2003
that
> can updated data from/to server? What means can be used to update the data
> (gprs?)? Is it too difficult to do this for someone with strong database
> skills i.e. does gprs etc. require a lot of knowledge of the underlying
> technology with a need to write code around it?
>
> If access is a problem then we can move to SQL Server, but is this at all
> possible?
>
> Thanks
>
> Regards
>
>


Relevant Pages

  • Re: Webservice SQL logon fails on production IIS server
    ... Do you have the two machines in one domain? ... Martin Kulov ... Anonymous access is not enabled on any of> the intranet IIS web services. ... They also work correctly when the services are> hosted on an IIS server on the same machine as the SQL Server. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Webservice SQL logon fails on production IIS server
    ... authentication for SQL Server authentication because the stored procedures ... The web services work correctly when they are hosted ... hosted on an IIS server on the same machine as the SQL Server. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: HTTP endpoint WSDL fails to be created; wsdl does not exist (S
    ... IIS is not involved with nor is it needed for web services set up in SQL Server 2005. ... SQL Server works directly with http.sys to set up the endpoint. ... In general you probably wouldn't have IIS running on the server that was running SQL Server, ...
    (microsoft.public.sqlserver.setup)
  • Re: Sql Server 2005: Get a list of all configured Web Services in the "Object Explorer"
    ... > Studio" where i can see these Web Services. ... Hm, when I think of it, I might have seen an Endpoints node under Security, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server SP3 at ...
    (comp.databases.ms-sqlserver)
  • Re: Sql web services
    ... Fundamentally SQL Server doesnot support a direct call as Web Services. ... need to implement the web service component and from the component you are ... "KPH" wrote in message ...
    (microsoft.public.sqlserver.programming)

Quantcast