EngineName connection parameter [ENG]

Function

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

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

See also

“Identifiers” in Chapter 2, “SQL Language Elements,” in Reference: Building Blocks, Tables, and Procedures.

“Database server naming restrictions [-n]” in Chapter 1, “Running the Database Server,” in the Utility Guide

“How connection parameters work”

Examples

Connect to a server named Guelph:

ENG=Guelph