ServerName (Server) connection parameter

{ ServerName | Server }=database-server-name-string

Network servers or personal servers.

database-server-name-string If you are starting a database server automatically, 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:
- begin with white space, single quotes, or double quotes
- end with white space
- contain semicolons, forward slashes (/), or backslashes (\)
- be longer than 250 bytes
- contain spaces when they are running on Unix
Long database server names are truncated to different lengths depending on the protocol.

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:
- 40 bytes for Windows shared memory
- 31 bytes for Unix shared memory
- 40 bytes for TCP/IP

The default local database server.

EngineName and ENG are accepted for backward compatibility, but are deprecated.

When a database server starts, it attempts to become the default database server on that computer. The first database server to start when there is no default server becomes the default database server. Shared memory connection attempts on that computer that do not explicitly specify a database server name connect to the default server.

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

If you are connecting over TCP/IP and use the Host connection parameter, ServerName is not required if the host name is provided.

In the Connect window, and in the ODBC Configuration For SQL Anywhere window, this is the Server Name field.

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.

It is recommended that you use the -xd option for database servers being used by deployed applications, and that all clients explicitly specify the name of the database server to which they should connect by using the Server connection parameter. This ensures that the database connects to the correct database server when a computer is running multiple SQL Anywhere database servers.

Connect to a server named Guelph:

Server=Guelph

ServerName (Server) connection parameter

Syntax

Usage

Allowed values

Default

Remarks

Note

See also

Example