Hi all,

I've been assigned the task of porting parts of our product over to the
Symbol MC-9060 RFID Handheld unit which runs PocketPC 2003. I've been a
developer for almost 10 years now, and just starting on the Pocket PC
Bandwagon... This unit is pretty slick, has the traditional
WIFI/ActiveSync/Bluetooth PocketPC features.

Our product typically runs Client/Server using TCPIP. Unfortunately, our
product uses a proprietary database (I know, I know.. ) & Due to the nature
of the environment our customers work in, not all customers are capable of
having wireless-networks in and around the building. Our preliminary
thought is that we would allow the customer to a) use the wireless network
if its available b) if no wireless network, copy portions of the database to
the handheld unit. In both cases, we would like to be able to make
reads/updates to our database, whether is an instant update, or its done on
the handheld, then "synced" back into the database when the handheld is
dropped in the cradle.

Does ActiveSync have a mechanism where you can write code to dump other
types of databases/files etc to the handheld unit? Is there some interface
into ActiveSync I can utilize to essentially "merge" changes from the
handheld unit to the PC?

I would appreciate any feedback or thoughts you may have .....

Cheers,

Mike
doner at obtain dot com

Re: PocketPC Database Question. by ctacke/>

ctacke/>
Thu Apr 27 13:21:43 CDT 2006

It's called an ActiveSync Service Provider (Google can help you find more
info). There's a sample in the AS SDK, which is part of the Pocket PC SDKs,
called StockPor

-Chris


"Mike Doner" <doner@obtain.com> wrote in message
news:OSkVVUiaGHA.4564@TK2MSFTNGP03.phx.gbl...
> Hi all,
>
> I've been assigned the task of porting parts of our product over to the
> Symbol MC-9060 RFID Handheld unit which runs PocketPC 2003. I've been a
> developer for almost 10 years now, and just starting on the Pocket PC
> Bandwagon... This unit is pretty slick, has the traditional
> WIFI/ActiveSync/Bluetooth PocketPC features.
>
> Our product typically runs Client/Server using TCPIP. Unfortunately, our
> product uses a proprietary database (I know, I know.. ) & Due to the
> nature of the environment our customers work in, not all customers are
> capable of having wireless-networks in and around the building. Our
> preliminary thought is that we would allow the customer to a) use the
> wireless network if its available b) if no wireless network, copy portions
> of the database to the handheld unit. In both cases, we would like to be
> able to make reads/updates to our database, whether is an instant update,
> or its done on the handheld, then "synced" back into the database when the
> handheld is dropped in the cradle.
>
> Does ActiveSync have a mechanism where you can write code to dump other
> types of databases/files etc to the handheld unit? Is there some interface
> into ActiveSync I can utilize to essentially "merge" changes from the
> handheld unit to the PC?
>
> I would appreciate any feedback or thoughts you may have .....
>
> Cheers,
>
> Mike
> doner at obtain dot com
>



Re: PocketPC Database Question. by David

David
Thu Apr 27 13:47:44 CDT 2006

We have pretty much the same requirements environmentally; the user may at
times be connected to a network, but most of the time they're not. We chose
to bring the data locally into SQL CE and operate like they're only
connected to the network when it's time to synchronize data. For
synchronizing, you can go either replication or RDA; we chose RDA, but
either would work. Data changes are sent back to the database through a
webservice for custom logic.

David

"Mike Doner" <doner@obtain.com> wrote in message
news:OSkVVUiaGHA.4564@TK2MSFTNGP03.phx.gbl...
> Hi all,
>
> I've been assigned the task of porting parts of our product over to the
> Symbol MC-9060 RFID Handheld unit which runs PocketPC 2003. I've been a
> developer for almost 10 years now, and just starting on the Pocket PC
> Bandwagon... This unit is pretty slick, has the traditional
> WIFI/ActiveSync/Bluetooth PocketPC features.
>
> Our product typically runs Client/Server using TCPIP. Unfortunately, our
> product uses a proprietary database (I know, I know.. ) & Due to the
> nature of the environment our customers work in, not all customers are
> capable of having wireless-networks in and around the building. Our
> preliminary thought is that we would allow the customer to a) use the
> wireless network if its available b) if no wireless network, copy portions
> of the database to the handheld unit. In both cases, we would like to be
> able to make reads/updates to our database, whether is an instant update,
> or its done on the handheld, then "synced" back into the database when the
> handheld is dropped in the cradle.
>
> Does ActiveSync have a mechanism where you can write code to dump other
> types of databases/files etc to the handheld unit? Is there some interface
> into ActiveSync I can utilize to essentially "merge" changes from the
> handheld unit to the PC?
>
> I would appreciate any feedback or thoughts you may have .....
>
> Cheers,
>
> Mike
> doner at obtain dot com
>



Re: PocketPC Database Question. by r_z_aret

r_z_aret
Fri Apr 28 16:57:31 CDT 2006

On Thu, 27 Apr 2006 14:21:43 -0400, "<ctacke/>"
<ctacke[@]opennetcf[dot]com> wrote:

>It's called an ActiveSync Service Provider (Google can help you find more
>info). There's a sample in the AS SDK, which is part of the Pocket PC SDKs,
>called StockPor

RAPI is an alternate approach. I've never even tried to write a
Service Provider, so I can't compare well. I think a Service Provider
is more tightly coupled with ActiveSync, and perhaps more subject to
its control. A program running RAPI can do just about anything on the
desktop and a lot on the handhelds.


>
>-Chris
>
>
>"Mike Doner" <doner@obtain.com> wrote in message
>news:OSkVVUiaGHA.4564@TK2MSFTNGP03.phx.gbl...
>> Hi all,
>>
>> I've been assigned the task of porting parts of our product over to the
>> Symbol MC-9060 RFID Handheld unit which runs PocketPC 2003. I've been a
>> developer for almost 10 years now, and just starting on the Pocket PC
>> Bandwagon... This unit is pretty slick, has the traditional
>> WIFI/ActiveSync/Bluetooth PocketPC features.
>>
>> Our product typically runs Client/Server using TCPIP. Unfortunately, our
>> product uses a proprietary database (I know, I know.. ) & Due to the
>> nature of the environment our customers work in, not all customers are
>> capable of having wireless-networks in and around the building. Our
>> preliminary thought is that we would allow the customer to a) use the
>> wireless network if its available b) if no wireless network, copy portions
>> of the database to the handheld unit. In both cases, we would like to be
>> able to make reads/updates to our database, whether is an instant update,
>> or its done on the handheld, then "synced" back into the database when the
>> handheld is dropped in the cradle.
>>
>> Does ActiveSync have a mechanism where you can write code to dump other
>> types of databases/files etc to the handheld unit? Is there some interface
>> into ActiveSync I can utilize to essentially "merge" changes from the
>> handheld unit to the PC?
>>
>> I would appreciate any feedback or thoughts you may have .....
>>
>> Cheers,
>>
>> Mike
>> doner at obtain dot com
>>
>

-----------------------------------------
To reply to me, remove the underscores (_) from my email address (and please indicate which newsgroup and message).

Robert E. Zaret, eMVP
PenFact, Inc.
20 Park Plaza, Suite 478
Boston, MA 02116
www.penfact.com