Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Connection parameters and network protocol options » Connection parameters

 

ServerName connection parameter [ENG]

Specifies the name of a running database server to which you want to connect. This is a synonym for EngineName.

Usage

Network servers or personal servers.

Values

String

Default

The default local database server.

Remarks

ServerName is not needed if you want to connect to the default local database server.

You need to supply a ServerName if more than one local database server is running, or if you want to connect to a network server. In the Connect window, and in the ODBC Configuration For SQL Anywhere 11 window, this is the Server Name field.

If you are autostarting a server, you can provide a server name using this parameter.

The server name is interpreted according to the character set of the client computer. Non-ASCII characters are not recommended in server names.

Names must be valid identifiers. Database server names cannot:

On Windows and Unix, version 9.0.2 and earlier clients cannot connect to version 10.0.0 and later database servers with names longer than the following lengths:

Note

It is recommended that you include the ServerName parameter in connection strings for deployed applications. This ensures that the application connects to the correct server in the case where a computer is running multiple SQL Anywhere database servers, and can help prevent timing-dependent connection failures.

See also
Example

Connect to a server named Guelph:

ENG=Guelph