Collection Contents Index Encryption connection parameter [ENC] Next PDF

SQL Anywhere® Server - Database Administration  > Connection Parameters and Network Protocol Options  > Connection parameters

EngineName connection parameter [ENG]


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

Usage

Network servers or personal servers.

Values

String

Default

The default local database server.

Remarks

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

You need to supply an EngineName if more than one local database server is running, or if you want to connect to a network server. In the Connect dialog, and in the ODBC Administrator, 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. Long server names are truncated to different lengths depending on the protocol.

Protocol Truncation length
TCP/IP 250 bytes
Shared memory 250 bytes
SPX 32 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:

Note

It is recommended that you include the EngineName 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

Collection Contents Index Encryption connection parameter [ENC] Next PDF