SQL Anywhere Mobile - 1 remote database being Used in 2 different locations

Author

1 remote database being Used in 2 different locations

Kevin Dunn

2005-08-29, 8:26 pm

All:
We are using ASA 9.01.1841 and the situation we have is an extracted database for remoteuser1 was sent to 2 different people at different locations. They are both synching to our consolidated database and I don't see any errors. I would expect to see an error dealing with the log offset or progress offset being out of synch. Shouldn't this be causing errors to show up?

Thanks,

--
Kevin Dunn
Email: kevin.dunn@spsinc.com
Home Email: kdunn2@carolina.rr.com
H: 704-263-2450
W: 704-544-5501 ext 295

Greg Fenton

2005-08-30, 3:25 am

Kevin Dunn wrote:
> All:
> We are using ASA 9.01.1841 and the situation we have is an extracted
> database for remoteuser1 was sent to 2 different people at different
> locations. They are both synching to our consolidated database and I
> don't see any errors. I would expect to see an error dealing with the
> log offset or progress offset being out of synch. Shouldn't this be
> causing errors to show up?
>

How many times have each synchronized?

I would expect that after both have successfully synchronized once, and
assuming neither "-ra" nor "-rb" are being used in the ML startup
parameters, that the first remote will fail to synchronize from that
point on.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

David Fishburn

2005-08-30, 9:30 am

"Kevin Dunn" <nospam_kevin.dunn@spsinc.com> wrote in
news:43135b00$1@foru
ms-2-dub of sybase.public.sqlanywhere.mobilink:

KD> We are using ASA 9.01.1841 and the situation we have is an
KD> extracted database for remoteuser1 was sent to 2 different people
KD> at different locations. They are both synching to our
KD> consolidated database and I don't see any errors. I would expect
KD> to see an error dealing with the log offset or progress offset
KD> being out of synch. Shouldn't this be causing errors to show up?

Yes, after each of the remotes sync 2 times (for sure), you should see
an error.

Can you show the output from dbmlsync after each sync from the 2
remotes.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links