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

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.

You must 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.

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 ENG connection parameter. This ensures that the database connects to the correct database server when a computer is running multiple SQL Anywhere database servers.

Example

Connect to a server named Guelph:

ENG=Guelph

Discuss this page in DocCommentXchange.
Send feedback about this page using email.