SQL Anywhere Mobile - Why is the Mobilink Server ignoring the rs switch?

Author

Why is the Mobilink Server ignoring the rs switch?

Chance

2005-09-30, 9:23 am

9.0.1 (2052)

This is the exact command line:

dbsvc -rs blwmultistore -as -i -s auto -t mobilink -w blconsolidated
"C:\Program Files\Sybase\SQL Anywhere 9\win32\dbmlsrv9.exe" -c
"DSN=blwmultistore" -v+ -dl -o ml.txt -vcrs -o debug.txt -zu+

--the -rs switch is the switch to setup the dependency according to the
documentation. It doesn't seem to matter where I put it in the service setup
script, though. dbsvc seems to be ignoring it.

Any help appreciated,
--
Chance
Lead Software Engineer
Research & Development
Computerworks/Booklog
chance@booklog.com

--
Chance
Lead Software Engineer
Research & Development
Computerworks/Booklog
chance@booklog.com

Blog:
http://chance.PBDJMagazine.com

Nick Elson

2005-09-30, 11:24 am

Here's a 2nd thought. It is probably creating the necessary registry
entries
but it could still fail if you fail to provide -rs with the correct
svc_name!

At one level it is just a (possibly even random) string of characters.
But at the same time it must match **precisely** match the windows
name for the service named in the dependency.

If you have gotten this wrong then you should see this kind of error
when you try to launch it from the cmdline

C:\> net start ASANYm_blconsolidate
d
System error 1075 has occurred.

The dependency service does not exist or has been marked for
deletion.

which would confirm this is your problem.

You need to match the Windows name(s) for that service. We prefix
our services with an 'ASANYs_' or 'ASANYe_' **type specific**
kind of identification. So when you see a service name with dbsvc -l
and it comes out as, say,

C:>dbsvc -l
Adaptive Server Anywhere Service Utility Version 9.0.2.3169
ASA Services:
blconsolidated
blwmultistore

that would mean there are (or should be) these real service names for
those (is strictly iAnywhere ASA and ML services)

ASANYm_blconsolidate
d
or Adaptive Server Anywhere - blconsolidated
and
ASANYs_blwmultistore
(if dbsrv9) or ASANYe_blwmultistore
(if dbeng9)
or Adaptive Server Anywhere - blwmultistore

The latter names for each are the Display names and are the ones you
will see in the Windows Service Manager or a 'net start' listing. The
former names for each are the registry key names or (a.k.a) the
'Real service name' for the service.

To use this you need to specify one or the other of them as

dbsvc -rs ASANYs_blwmultistore
-w blconsolidated ....
or

dbsvc -rs "Adaptive Server Anywhere - blwmultistore" -w
blconsolidated ....

[double quotes required]

It's a common enough error in a confusing patch of Windows / iAnywhere
naming conventions.

"Chance" <chance@booklog.com> wrote in message
news:433d4231$1@foru
ms-1-dub...
> 9.0.1 (2052)
>
> This is the exact command line:
>
> dbsvc -rs blwmultistore -as -i -s auto -t mobilink -w blconsolidated
> "C:\Program Files\Sybase\SQL Anywhere 9\win32\dbmlsrv9.exe" -c
> "DSN=blwmultistore" -v+ -dl -o ml.txt -vcrs -o debug.txt -zu+
>
> --the -rs switch is the switch to setup the dependency according to the
> documentation. It doesn't seem to matter where I put it in the service
> setup
> script, though. dbsvc seems to be ignoring it.
>
> Any help appreciated,
> --
> Chance
> Lead Software Engineer
> Research & Development
> Computerworks/Booklog
> chance@booklog.com
>
>
> --
> Chance
> Lead Software Engineer
> Research & Development
> Computerworks/Booklog
> chance@booklog.com
>
> Blog:
> http://chance.PBDJMagazine.com
>

David Fishburn

2005-09-30, 8:24 pm

"Chance" <chance@booklog.com> wrote in news:433d4231$1@foru
ms-1-dub of
sybase.public.sqlanywhere.mobilink:

C> 9.0.1 (2052)

If you are just in development, I suggest you move up to 902 plus the
current 902 EBF.

--
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]

Reg Domaratzki $iAnywhere Solutions$

2005-10-27, 8:20 am

This post showed up in my sent items mailbox, but not in the newsgroup...

You need to specify the "Real Service Name" after the -rs switch. The real
service name will start with "ASANY", but yours does not. The steps below
show the successful creation of an engine service and MobiLink service with
a dependency between the two.

[d:\temp] [0] [901] dbinit temp.db
Adaptive Server Anywhere Initialization Utility Version 9.0.1.2069
Creating system tables
Collation sequence: 1252LATIN1
Creating system views
Setting permissions on system tables and views
Setting option values
Initializing UltraLite deployment option
Database "temp.db" created successfully

[d:\temp] [0] [901] dbsvc -as -i -s Manual -t Standalone -w EngineSvc
" d:\sybase\asa901\win
32\dbeng9.exe" "d:\temp\temp.db"
Adaptive Server Anywhere Service Utility Version 9.0.1.2069
Service "EngineSvc" was created successfully.

[d:\temp] [0] [901] dbsvc -g EngineSvc
Adaptive Server Anywhere Service Utility Version 9.0.1.2069
Service "EngineSvc":
Personal Server
Real service name: ASANYe_EngineSvc
Manual Startup
Using LocalSystem account
Allowed to interact with desktop
Executable: d:\sybase\asa901\win
32\dbeng9.exe
Service command line options: d:\temp\temp.db

[d:\temp] [0] [901] dbdsn -ws temp_dsn -c
" eng=temp;dbn=temp;ui
d=dba;pwd=sql;dbf=d:
\temp\temp.db"
Adaptive Server Anywhere Data Source Utility Version 9.0.1.2069
System Data Source "temp_dsn" written to registry.

[d:\temp] [0] [901] dbsvc -rs ASANYe_EngineSvc -as -i -s Manual -t
MobiLink -w MobilinkSvc " d:\sybase\asa901\win
32\dbmlsrv9.exe" -c
dsn=temp_dsn -v+ -dl -o d:\temp\ml.txt -zu+
Adaptive Server Anywhere Service Utility Version 9.0.1.2069
Service "MobilinkSvc" was created successfully.

[d:\temp] [0] [901] dbsvc -u MobiLinkSvc
Adaptive Server Anywhere Service Utility Version 9.0.1.2069
Service "MobiLinkSvc" start pending.
Service "MobiLinkSvc" was started successfully.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"Chance" <chance@booklog.com> wrote in message
news:433d4231$1@foru
ms-1-dub...
> 9.0.1 (2052)
>
> This is the exact command line:
>
> dbsvc -rs blwmultistore -as -i -s auto -t mobilink -w blconsolidated
> "C:\Program Files\Sybase\SQL Anywhere 9\win32\dbmlsrv9.exe" -c
> "DSN=blwmultistore" -v+ -dl -o ml.txt -vcrs -o debug.txt -zu+
>
> --the -rs switch is the switch to setup the dependency according to the
> documentation. It doesn't seem to matter where I put it in the service
setup

> script, though. dbsvc seems to be ignoring it.
>
> Any help appreciated,
> --
> Chance
> Lead Software Engineer
> Research & Development
> Computerworks/Booklog
> chance@booklog.com
>
>
> --
> Chance
> Lead Software Engineer
> Research & Development
> Computerworks/Booklog
> chance@booklog.com
>
> Blog:
> http://chance.PBDJMagazine.com
>
>

Sponsored Links