Re: Replicated DB and synchronize with PPC with active Sync

From: Michael \(michka\) Kaplan [MS] (michkap_at_online.microsoft.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 09:02:46 -0800

See http://trigeminal.com/usenet/usenet011.asp for easy guid/string stuff. 

-- 
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.
"***" <anonymous@discussions.microsoft.com> wrote in message
news:211b01c3fc5a$43d11d20$a001280a@phx.gbl...
> 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?
> >> >
> >> >
> >>
> >>
> >
> >
> >.
> >