EngineName connection parameter [ENG]

Function

Synonym for ServerName. The name of a running database server to which you want to connect.

Usage

Network servers

Values

String

Default

The default local database server.

Description

You need to supply an EngineName to connect to a network server. In the Connect dialog, and in the ODBC Administrator, this is the Server Name field.

The server name is interpreted according to the character set of the client machine. Multi-byte characters are not recommended in server names.

Names must be a valid identifier. Long server names are truncated to different lengths depending on the protocol.

Protocol

Truncation Length

UNIX shared memory

31 bytes

non-UNIX shared memory

40 bytes

TCP/IP

40 bytes

Named Pipes

8 bytes

See also

“Identifiers” in Chapter 3, “SQL Language Elements,” in Sybase IQ Reference Manual.

“Database switches” in Chapter 1, “Running the Database Server,”.Sybase IQ Utility Guide

“How connection parameters work”

Examples

Connect to a server named Guelph:

ENG=Guelph