Re: Replicated DB and synchronize with PPC with active Sync

From: *** (anonymous_at_discussions.microsoft.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 03:18:31 -0800

Hi Doug,

How did you convert the s_Guid into String? In the design
view is dous not allow it!
As I understand it works now for you, can you indicate
what you did exactly, would be much appreciated.

I'm using SprintDB on my PDA. This works great as you can
even supports relationships (most others don't).

*** H.

>-----Originalnachricht-----
>SQL Server will not be used for this consumer
application, where I'll have a
>maximum of 2-3 desktops and 2-3 handhelds.
>
>There was no problem in converting s_GUIDs into string
and back: strings for
>the handhelds and 16-bit bytes for the desktops.
>You will need to trigger an application before and after
ActiveSync to run
>your converison application.
>There is complete control over the schema columns. Just
act on them like
>you would any other table. Insert, Delete, Update work.
>
>Anyway, after playing around this morning, I have created
a schema, and
>mechanism to synchronize without JRO.
>
>Doug
>
>This posting is provided "IS AS" with complete
warranties, and confers all
>rights.
>
>
>"Michael (michka) Kaplan [MS]"
<michkap@online.microsoft.com> wrote in
>message news:eysRUIL%23DHA.3816@TK2MSFTNGP09.phx.gbl...
>> It is not realistic to try and mimic the desktop
replication schema onto a
>> CE device (especially since you cannot change the
system columns in the
>> desktop db and thus there is no purpose to duplicating
them).
>>
>> You may want to look into SQL Server -- Windows CE
edition.
>>
>>
>> --
>> MichKa [MS]
>> NLS Collation/Locale/Keyboard Development
>> Globalization Infrastructure and Font Technologies
>>
>> This posting is provided "AS IS" with
>> no warranties, and confers no rights.
>>
>>
>>
>> "Doug T." <dat@dat.com> wrote in message
>> news:u%23xGKkc9DHA.1804@TK2MSFTNGP12.phx.gbl...
>> > Same problem as I described yesterday also.
>> > The option I am trying now is to:
>> > Convert local Access DB with S_GUID from 16-bit byte
to string.
>> > Active sync - synchronize Pocket PC and Access DB.
>> > When complete, convert Access DB from string to
s_GUID.
>> >
>> > This will require a system of producing string
s_GUID's on the Pocket
>PC.
>> >
>> > Would be much easier if there was native support of
s_GUID type in
>Pocket
>> > PC.
>> >
>> > I am not sure what will happen to the OLE Object -
s_Lineage.
>> >
>> > Doug
>> >
>> >
>> > "***" <hogeweide@yahoo.com> wrote in message
>> > news:953901c3ea37$f5e39720$a601280a@phx.gbl...
>> > > I'm trying to synchronize an replicated Access 2000
DB
>> > > with my Pocket PC (MS mobile 2003). The problem is
already
>> > > when the DB is copied to (and converted) the s_Guid
is not
>> > > copied or converted. The DB works on the pocket PC
and I
>> > > can also synchronize with a non replaicated DB but
not
>> > > with my replicated DB (even if it is the master)
because
>> > > of the inserted colums at the original replica
(like the
>> > > s_GUID).
>> > >
>> > > Anybody had the same problem or a solution?
>> >
>> >
>>
>>
>
>
>.
>

Loading