SQL Anywhere Feedback - Naming of server

Author

Naming of server

Martin Baur

2006-01-04, 1:23 pm

Hi there

If I give a server a name in Central Services, this name displays there and in Window's service panel.

However, as soon as I mount one db with -d some.db in the server's propery, the server name changes to that db's name, i.e. it has now the name "some".

This is extremly irritating to new users. They install a service, give it a name, mount a db named differently and still cannot connect because Central complains that it cannot find the server.

Why is this behavior? Why do I have to put -n server_name in the server's properties to GUARANTEE that the server keeps this name?

What is this good for?

Anyway, I prpopose to get rid of this automatic server name change.

--
Martin Baur

MindPower.com, IT-Services

Chris Keating(iAnywhere Solutions)

2006-01-04, 8:23 pm

The service name and the database server name are not related. A service
name can be anything and does not play any role in connectivity.

You should also review to understand the rules associated with the
naming of the server.

http://www.ianywhere.com/developer/...er_db_name.html

It is best practice to name the server using the -n server option.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

********************
********************
********************
*****************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

********************
********************
********************
*****************

Sponsored Links