Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Resuming disconnected synch...

6 posts in General Discussion Last posting was on 2005-10-28 20:14:09.0Z
John M. Posted on 2005-10-27 20:03:37.0Z
Sender: 7e98.43612fe0.1804289383@sybase.com
From: John M.
Newsgroups: ianywhere.public.general
Subject: Resuming disconnected synch...
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <43613299.7efd.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Oct 2005 13:03:37 -0700
X-Trace: forums-1-dub 1130443417 10.22.241.41 (27 Oct 2005 13:03:37 -0700)
X-Original-Trace: 27 Oct 2005 13:03:37 -0700, 10.22.241.41
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4889
Article PK: 31469

Is there a way to enable iAnywhere to resume a synch, once
it has been disconnected? What I need iAnywhere to do is if
the user starts a synch to our database, but gets
disconnected, I need iAnywhere to "pause". Once the user
regains a connection, it will resume the synch as if nothing
happend and at the place in the synch where it disconnected.

I've adjusted the keep_alive option to 0, added
KeepAliveInterval, KeepAliveTime, and
TcpMaxConnectRetransmissions to the TCP/IP Parameters in the
register, but that doesn't appear to do anything. All I see
during a synch, once I initiate a disconnect (via
disconnecting our AirCard WAN connection), is multiple
TCP/IP write errors and then iAnywhere says "Synchronization
Failed".

If I let the synch run through to completion (without
initiating a disconnect), it synch fine.

I'm running Adaptive Server 8.0.2.4513 on Windows XP Tablet
Edition.

Thanks,
John M.


Shuchit Posted on 2005-10-28 02:21:29.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Resuming disconnected synch...
From: Shuchit <me@privacy.net>
References: <43613299.7efd.1681692777@sybase.com>
Message-ID: <Xns96FCD528A17C6svelkarprivacynet@127.0.0.1>
User-Agent: Xnews/??.01.30 Hamster/2.0.6.0
X-Original-NNTP-Posting-Host: vpn-dub-064.sybase.com
X-Original-Trace: 27 Oct 2005 19:16:43 -0700, vpn-dub-064.sybase.com
Lines: 22
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 27 Oct 2005 19:16:44 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 27 Oct 2005 19:21:29 -0700
X-Trace: forums-1-dub 1130466089 10.22.108.75 (27 Oct 2005 19:21:29 -0700)
X-Original-Trace: 27 Oct 2005 19:21:29 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-2-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4890
Article PK: 8588


John M. wrote in news:43613299.7efd.1681692777@sybase.com:

> Is there a way to enable iAnywhere to resume a synch, once
> it has been disconnected? What I need iAnywhere to do is if
> the user starts a synch to our database, but gets
> disconnected, I need iAnywhere to "pause". Once the user
> regains a connection, it will resume the synch as if nothing
> happend and at the place in the synch where it disconnected.
>
> I'm running Adaptive Server 8.0.2.4513 on Windows XP Tablet
> Edition.

You need to upgrade to SQL Anywhere 9.0.2 for this. See the following part of
the documentation.

<http://tinyurl.com/dv3r7> which points to
<http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/
dbmlen9/00000066.htm>

Shuchit


John M. Posted on 2005-10-28 19:36:52.0Z
From: "John M." <jm@noemail.com>
Newsgroups: ianywhere.public.general
References: <43613299.7efd.1681692777@sybase.com> <Xns96FCD528A17C6svelkarprivacynet@127.0.0.1>
Subject: Re: Resuming disconnected synch...
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Original-NNTP-Posting-Host: 204.64.113.55
Message-ID: <43627cb6$1@forums-2-dub>
X-Original-Trace: 28 Oct 2005 12:32:06 -0700, 204.64.113.55
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Oct 2005 12:32:07 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Oct 2005 12:36:52 -0700
X-Trace: forums-1-dub 1130528212 10.22.108.75 (28 Oct 2005 12:36:52 -0700)
X-Original-Trace: 28 Oct 2005 12:36:52 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-2-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4891
Article PK: 31473

Is that the same as "pausing" the synch process? What we'd like to do is if
our mobile users get disconnected, we'd like the synch to temporarily
"pause" for a few minutes for a reconnect (and not show as being a sync
failed). Once the user reconnects, it resumes the synch as if nothing
happened. However, if the user doesn't not reconnect within a specified
time, the synch should fail like normal. Is this possible with the methods
you've started below (in the admin guide)?

Thanks,
John

"Shuchit" <me@privacy.net> wrote in message
news:Xns96FCD528A17C6svelkarprivacynet@127.0.0.1...
> John M. wrote in news:43613299.7efd.1681692777@sybase.com:
>
>> Is there a way to enable iAnywhere to resume a synch, once
>> it has been disconnected? What I need iAnywhere to do is if
>> the user starts a synch to our database, but gets
>> disconnected, I need iAnywhere to "pause". Once the user
>> regains a connection, it will resume the synch as if nothing
>> happend and at the place in the synch where it disconnected.
>>
>> I'm running Adaptive Server 8.0.2.4513 on Windows XP Tablet
>> Edition.
>
>
>
> You need to upgrade to SQL Anywhere 9.0.2 for this. See the following part
> of
> the documentation.
>
> <http://tinyurl.com/dv3r7> which points to
> <http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/
> dbmlen9/00000066.htm>
>
> Shuchit


Greg Fenton Posted on 2005-10-28 19:48:06.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Resuming disconnected synch...
References: <43613299.7efd.1681692777@sybase.com> <Xns96FCD528A17C6svelkarprivacynet@127.0.0.1> <43627cb6$1@forums-2-dub>
In-Reply-To: <43627cb6$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-t30.sybase.com
Message-ID: <43627f5a@forums-2-dub>
X-Original-Trace: 28 Oct 2005 12:43:22 -0700, gfenton-t30.sybase.com
Lines: 23
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Oct 2005 12:43:23 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Oct 2005 12:48:06 -0700
X-Trace: forums-1-dub 1130528886 10.22.108.75 (28 Oct 2005 12:48:06 -0700)
X-Original-Trace: 28 Oct 2005 12:48:06 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-2-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4892
Article PK: 31470


John M. wrote:
> Is that the same as "pausing" the synch process? What we'd like to do is if
> our mobile users get disconnected, we'd like the synch to temporarily
> "pause" for a few minutes for a reconnect (and not show as being a sync
> failed).

I do not believe that the feature works in this manner. However, you
can write a front-end to the synchronization process and handle the
end-user's experience in whatever way you care to.

Can you describe how you have the user's synchronizing right now? Is
there a "synch" button in an end-user application or something?

What development environment(s) are you working with?

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


John M. Posted on 2005-10-28 19:57:27.0Z
From: "John M." <jm@noemail.com>
Newsgroups: ianywhere.public.general
References: <43613299.7efd.1681692777@sybase.com> <Xns96FCD528A17C6svelkarprivacynet@127.0.0.1> <43627cb6$1@forums-2-dub> <43627f5a@forums-2-dub>
Subject: Re: Resuming disconnected synch...
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Original-NNTP-Posting-Host: 204.64.113.55
Message-ID: <4362818b$2@forums-2-dub>
X-Original-Trace: 28 Oct 2005 12:52:43 -0700, 204.64.113.55
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Oct 2005 12:52:44 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Oct 2005 12:57:27 -0700
X-Trace: forums-1-dub 1130529447 10.22.108.75 (28 Oct 2005 12:57:27 -0700)
X-Original-Trace: 28 Oct 2005 12:57:27 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-2-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4893
Article PK: 31472

We currently have a SQL Anywhere 8 database running on all of our mobile
users tablet PCs. The mobile users initiate a sync to the our servers
manually (via a sync button) in our custom application's GUI. The app
minimizes and SQL Anywhere takes over and handles the data syncs. After the
sync, the app "reappears" and its data is refreshed. We're using .Net for
the frontend client app, .net for some tasks on our servers, SQL Anywhere 8
(clients), SQL Server 2000 (server).

Thanks,
John M.

"Greg Fenton" <greg.fenton_NOSPAM_@ianywhere.com> wrote in message
news:43627f5a@forums-2-dub...
> John M. wrote:
>> Is that the same as "pausing" the synch process? What we'd like to do is
>> if our mobile users get disconnected, we'd like the synch to temporarily
>> "pause" for a few minutes for a reconnect (and not show as being a sync
>> failed).
>
> I do not believe that the feature works in this manner. However, you can
> write a front-end to the synchronization process and handle the end-user's
> experience in whatever way you care to.
>
> Can you describe how you have the user's synchronizing right now? Is
> there a "synch" button in an end-user application or something?
>
> What development environment(s) are you working with?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/


Greg Fenton Posted on 2005-10-28 20:14:09.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Resuming disconnected synch...
References: <43613299.7efd.1681692777@sybase.com> <Xns96FCD528A17C6svelkarprivacynet@127.0.0.1> <43627cb6$1@forums-2-dub> <43627f5a@forums-2-dub> <4362818b$2@forums-2-dub>
In-Reply-To: <4362818b$2@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-t30.sybase.com
Message-ID: <43628575@forums-2-dub>
X-Original-Trace: 28 Oct 2005 13:09:25 -0700, gfenton-t30.sybase.com
Lines: 28
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Oct 2005 13:09:26 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Oct 2005 13:14:09 -0700
X-Trace: forums-1-dub 1130530449 10.22.108.75 (28 Oct 2005 13:14:09 -0700)
X-Original-Trace: 28 Oct 2005 13:14:09 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-2-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4894
Article PK: 17461


John M. wrote:
> The app
> minimizes and SQL Anywhere takes over and handles the data syncs. After the
> sync, the app "reappears" and its data is refreshed. We're using .Net for
> the frontend client app, .net for some tasks on our servers, SQL Anywhere 8
> (clients), SQL Server 2000 (server).
>

So you're app is calling out to dbmlsync directly. With that approach
there is not much control you have over the UI.

The other approach is to have your application call into the DBTools
library directly, calling the function DBSynchronizeLog(). This gives
you ultimate control over the user experience.

BTW: these posts would be better served in the MobiLink newsgroup:

sybase.public.sqlanywhere.mobilink

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