|
|
|
|
SQL CE sync with MSDE (ie. running on XP Home, with no IIS)
Hi,
I am trying to write an app that will run on XP Home (ie. no IIS), using
MSDE, but which will sync to SQL CE.
Can anyone offer some pointers or code samples (prefer C#), on how to do
this. All the articles I can find seem to suggest using replication, or RDA,
but both appear to use IIS, and SQL 2000.
Any help appreciated.
Thanks
Paul
220 15707
From: "Paul Aspinall"
Newsgroups: microsoft.public.dotnet.framework.compactframework,microsoft.public.dotnet.languages.csharp,microsoft.public.pocketpc.developer,microsoft.public.sqlserver.ce,microsoft.public.sqlserver.msde,microsoft.public.windowsce.app.development
Subject: SQL CE sync with MSDE (ie. running on XP Home, with no IIS)
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
Message-ID:
Date: Fri, 14 Jan 2005 12:08:44 GMT
NNTP-Posting-Host: 82.42.53.187
X-Trace: fe1.news.blueyonder.co.uk 1105704524 82.42.53.187 (Fri, 14 Jan 2005 12:08:44 GMT)
NNTP-Posting-Date: Fri, 14 Jan 2005 12:08:44 GMT
Path: TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!fr.ip.ndsoftware.net!border2.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!pe1.news.blueyonder.co.uk!blueyonder!fe1.news.blueyonder.co.uk.POSTED!53ab2750!not-for-mail
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.dotnet.languages.csharp:301808 microsoft.public.pocketpc.developer:88074 microsoft.public.sqlserver.ce:15707 microsoft.public.sqlserver.msde:19080 microsoft.public.windowsce.app.development:26878 microsoft.public.dotnet.framework.compactframework:69832
Hi,
I am trying to write an app that will run on XP Home (ie. no IIS), using
MSDE, but which will sync to SQL CE.
Can anyone offer some pointers or code samples (prefer C#), on how to do
this. All the articles I can find seem to suggest using replication, or RDA,
but both appear to use IIS, and SQL 2000.
Any help appreciated.
Thanks
Paul
Fri, 14 Jan 2005 12:08:44 GMT
"Paul Aspinall"
|
Re: SQL CE sync with MSDE (ie. running on XP Home, with no IIS)
Paul,
All the canned syncing strategies do require IIS for the plumbing. Have you
considered writing a device app that exports the data from SqlCe to XML or
CSV format, then copying that file to the device where a desktop app could
to the syncing?
Fri, 14 Jan 2005 10:02:37 -0500
" Ginny Caughey [MVP]"
|
Re: SQL CE sync with MSDE (ie. running on XP Home, with no IIS)
Paul,
Look at the Rapi class on www.opennetcf.org. Rapi apps can be written to
wait until there is a connection if you use CeRapiInit rather than
CeRapiInitEx.
Fri, 14 Jan 2005 10:17:15 -0500
" Ginny Caughey [MVP]"
|
|