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.

Shutting Mobilink from commandline

6 posts in General Discussion Last posting was on 2007-11-20 13:41:45.0Z
Herman Miller Posted on 2007-11-19 14:37:31.0Z
Sender: 7b86.47419c59.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Shutting Mobilink from commandline
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47419fab.7bb3.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Nov 2007 06:37:31 -0800
X-Trace: forums-1-dub 1195483051 10.22.241.41 (19 Nov 2007 06:37:31 -0800)
X-Original-Trace: 19 Nov 2007 06:37:31 -0800, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6581
Article PK: 4829

Is there anyway to stop SQL Server from the commandline? I
have a database event that starts the Mobilink client upon
database startup. I need to update the event and I get an
error that says, event in use.


Kory Hodgson <khodgson Posted on 2007-11-19 14:55:08.0Z
From: Kory Hodgson <khodgson@nospam_sybase.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Shutting Mobilink from commandline
References: <47419fab.7bb3.1681692777@sybase.com>
In-Reply-To: <47419fab.7bb3.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: khodgson-pc.sybase.com
X-Original-NNTP-Posting-Host: khodgson-pc.sybase.com
Message-ID: <4741a3cc$1@forums-1-dub>
Date: 19 Nov 2007 06:55:08 -0800
X-Trace: forums-1-dub 1195484108 10.25.98.119 (19 Nov 2007 06:55:08 -0800)
X-Original-Trace: 19 Nov 2007 06:55:08 -0800, khodgson-pc.sybase.com
Lines: 15
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6583
Article PK: 4831

Herman,

Check out this in the online help:

MobiLink - Server Administration > MobiLink Utilities

MobiLink stop utility [mlstop]

Herman Miller wrote:
> Is there anyway to stop SQL Server from the commandline? I
> have a database event that starts the Mobilink client upon
> database startup. I need to update the event and I get an
> error that says, event in use.


Kory Hodgson <khodgson Posted on 2007-11-19 14:56:34.0Z
From: Kory Hodgson <khodgson@nospam_sybase.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Shutting Mobilink from commandline
References: <47419fab.7bb3.1681692777@sybase.com> <4741a3cc$1@forums-1-dub>
In-Reply-To: <4741a3cc$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: khodgson-pc.sybase.com
X-Original-NNTP-Posting-Host: khodgson-pc.sybase.com
Message-ID: <4741a422$1@forums-1-dub>
Date: 19 Nov 2007 06:56:34 -0800
X-Trace: forums-1-dub 1195484194 10.25.98.119 (19 Nov 2007 06:56:34 -0800)
X-Original-Trace: 19 Nov 2007 06:56:34 -0800, khodgson-pc.sybase.com
Lines: 21
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6584
Article PK: 4832

Here is a link to the online version:

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbmlen10/ml-dbmlstop-ml-utilities.html

Kory Hodgson wrote:
> Herman,
>
> Check out this in the online help:
>
> MobiLink - Server Administration > MobiLink Utilities
>
> MobiLink stop utility [mlstop]
>
>
>
> Herman Miller wrote:
>> Is there anyway to stop SQL Server from the commandline? I
>> have a database event that starts the Mobilink client upon
>> database startup. I need to update the event and I get an
>> error that says, event in use.


Herman Miller Posted on 2007-11-19 14:59:04.0Z
Sender: 7b86.47419c59.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: Shutting Mobilink from commandline
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4741a4b8.7bff.1681692777@sybase.com>
References: <4741a422$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Nov 2007 06:59:04 -0800
X-Trace: forums-1-dub 1195484344 10.22.241.41 (19 Nov 2007 06:59:04 -0800)
X-Original-Trace: 19 Nov 2007 06:59:04 -0800, 10.22.241.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6586
Article PK: 4834

It looks like mlstop is for the Mobilink Server, is this for
the Mobilink Client as well (dbmlsync.exe)?

> Here is a link to the online version:
>
>
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbmlen10/ml-dbmlstop-ml-utilities.html
>
>
> Kory Hodgson wrote:
> > Herman,
> >
> > Check out this in the online help:
> >
> > MobiLink - Server Administration > MobiLink Utilities
> >
> > MobiLink stop utility [mlstop]
> >
> >
> >
> > Herman Miller wrote:
> >> Is there anyway to stop SQL Server from the
> commandline? I >> have a database event that starts the
> Mobilink client upon >> database startup. I need to update
> the event and I get an >> error that says, event in use.


Kory Hodgson <khodgson Posted on 2007-11-19 15:18:27.0Z
From: Kory Hodgson <khodgson@nospam_sybase.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Shutting Mobilink from commandline
References: <4741a422$1@forums-1-dub> <4741a4b8.7bff.1681692777@sybase.com>
In-Reply-To: <4741a4b8.7bff.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: khodgson-pc.sybase.com
X-Original-NNTP-Posting-Host: khodgson-pc.sybase.com
Message-ID: <4741a943$1@forums-1-dub>
Date: 19 Nov 2007 07:18:27 -0800
X-Trace: forums-1-dub 1195485507 10.25.98.119 (19 Nov 2007 07:18:27 -0800)
X-Original-Trace: 19 Nov 2007 07:18:27 -0800, khodgson-pc.sybase.com
Lines: 55
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6587
Article PK: 4835

Herman,

Sorry, I thought you where referring to the server. You could use an
event hook, depending when you want the client to shutdown.

I am not overly clear on your scenario however.

Take a look at the following section:

MobiLink - Client Administration > SQL Anywhere Clients

Scheduling synchronization

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbmnen10/mn-scheduling-customizing-ml-asa.html

So from this it says that if you setup a schedule using dbmlsync options
it can only be stopped by the user, however you can setup
synchronization with event hooks and in this case you could
programmatically stop the client from your hook code.

See:

MobiLink - Client Administration > SQL Anywhere Clients > Scheduling
synchronization

Initiating synchronization with event hooks

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbmnen10/mn-mc-asa-s-6547476.html

Herman Miller wrote:
> It looks like mlstop is for the Mobilink Server, is this for
> the Mobilink Client as well (dbmlsync.exe)?
>
>> Here is a link to the online version:
>>
>>
> http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbmlen10/ml-dbmlstop-ml-utilities.html
>>
>> Kory Hodgson wrote:
>>> Herman,
>>>
>>> Check out this in the online help:
>>>
>>> MobiLink - Server Administration > MobiLink Utilities
>>>
>>> MobiLink stop utility [mlstop]
>>>
>>>
>>>
>>> Herman Miller wrote:
>>>> Is there anyway to stop SQL Server from the
>> commandline? I >> have a database event that starts the
>> Mobilink client upon >> database startup. I need to update
>> the event and I get an >> error that says, event in use.


David Fishburn Posted on 2007-11-20 13:41:45.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Shutting Mobilink from commandline
From: David Fishburn <fishburn_spam@off.ianywhere.com>
References: <47419fab.7bb3.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns99EE5841F43EFfishburnsybasecom@127.0.0.1>
User-Agent: Xnews/2005.10.18 Hamster/2.1.0.0
NNTP-Posting-Host: fishburn-m20.sybase.com
X-Original-NNTP-Posting-Host: fishburn-m20.sybase.com
Date: 20 Nov 2007 05:41:45 -0800
X-Trace: forums-1-dub 1195566105 10.25.98.137 (20 Nov 2007 05:41:45 -0800)
X-Original-Trace: 20 Nov 2007 05:41:45 -0800, fishburn-m20.sybase.com
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6601
Article PK: 4850

Herman Miller wrote in news:47419fab.7bb3.1681692777@sybase.com
of ianywhere.public.general:

HM> Is there anyway to stop SQL Server from the commandline?

For that you would have to consult the Microsoft documentation.


--
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 (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

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

Case-Express - to report bugs
http://case-express.sybase.com

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