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:

begin with white space, single quotes, or double quotes
end with white space
contain semicolons
be longer than 250 bytes

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

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.

Example

Connect to a server named Guelph:

ENG=Guelph

Send feedback about this page via email or DocCommentXchange