Send data through ActiveSync

From: Mystic Mong (alastair.williamson_at_tiso.co.uk)
Date: 05/28/04 

Date: Fri, 28 May 2004 20:15:29 +0100

Hi everyone,

Can someone point me in the right direction towards doing the following?
It's not something I've tried to do before so I am not entirely sure what
the best method would be:

I have an app that runs on PPC2003, written in VB.Net (running on Symbol
8846 units). Data is collected in a local SqlCe database and in normal
circumstances is sent via a wireless network to a main Sql Server 2000
database.

However, in some circumstances we need to be able to work in remote sites
(no wireless network, no main server, no network/internet connectivity),
collect the data as usual but then transfer the data collected to an Access
database on a laptop (allow I may end up changing the data source on the
laptop to MSDE). Now, at the moment I get the units to create a local file
containing the data then cradle the unit and sync it with the laptop using
ActiveSync. Then we use File Explorer to copy the file to the laptop and run
an import routine on the laptop database. It works fine enough but it is a
bit convoluted for end users (and there is room for error).

So, I was wondering if it is possible to send the data direct from the SqlCe
database on the unit to the data source on the laptop when the unit is
cradled? I don't want to use the built in Synchronise thingy of ActiveSync I
want to be able to fire the send manually when required.

Any clues? I'll be happy to fill in any missing information.

Cheers

C-Ya Aly

Relevant Pages

  • Re: Send data through ActiveSync
    ... Develop an Efficient Architecture based on SQL Server CE Replication ... Data is collected in a local SqlCe database and in normal ... > (no wireless network, no main server, no network/internet connectivity), ... > laptop to MSDE). ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: OT: Which software?
    ... I will be working on a site that is built in ASP ... because sitting 16hrs/day behind a laptop is not the ... I guess cheaper, compared to a laptop. ... >> Then developing a database + ASP seems to be quite a big thing to get ...
    (alt.internet.search-engines)
  • Re: Record locking
    ... thinking they just were filling the database ... > write on a Win2K laptop at home which has it's own copy of SQL Server on ... > its life on my laptop something has altered this table. ... In SQL Server it is possible ...
    (microsoft.public.access.setupconfig)
  • Re: Critique of Robert C. Martins "Agile Principles, Patterns, and Practices"
    ... Robert Martin wrote: ... full database on a laptop has not been a problem for the last 10 years. ... Eclipse uses more memory and CPU on my laptop than my SQL Server, ... There are ongoing battles between DBA's and app developers because ...
    (comp.object)
  • Re: Database programminf question...
    ... Does writing the data to the XML files on the laptop retain the ... files allowing them to be read back in without loosing any database ... the laptop SQL instance in a way that would allow using the DataSet/ ...
    (microsoft.public.dotnet.languages.csharp)