Host connection parameter

Host={ hostname | ip-address }[ :port-number ] ...

Anywhere. The Host connection parameter is optional for connections to a personal server, and recommended for connections to a network server.

hostname The name of the computer where the database server is running. The list of host values is a comma-separated list and it can optionally include a port number (separated by a colon). You can use localhost to identify the current computer.
ip-address This string must be specified in the form of an IP address and it can optionally include a port number (separated by a colon). The list of IP addresses is a comma-separated list.
If you specify an IPv6 address with a port number the address must include brackets before the port. For example, HOST=(fd77:ab34:2238::3894):8933, where 8933 is the port number.
port-number The port number used by the database server. The default port number is 2638.

None

The Host connection parameter specifies a hostname (or IP address) and optional port number that tell the client where a database server is running.

When you use the Host parameter, no UDP packets are sent if enough information is given to uniquely identify the server (a host name and a port number). If neither a port number nor database server name is given, the port number is assumed to be 2638 and the client does not perform a broadcast. However, if the client has a host name and database server name but no port number, it sends a UDP packet to port 2638 on the specified host to find the port number.

The Host connection parameter can take a list of host names, separated by commas. The hosts are attempted the in order given, with the exception that if the address stored in the database server address cache matches any one of the addresses specified by the Host connection parameter, then that one is tried first.

When the Host connection parameter is used, the ServerName connection parameter is optional. If the database server name is given, it is verified once the connection is made (the client ensures that the database server it is connected to has the specified name). It is recommended that you always use the ServerName parameter, particularly for embedded applications. See ServerName (Server) connection parameter.

Note

If you specify the Host connection parameter, you cannot specify the CommLinks (LINKS) connection parameter. You should only use the CommLinks (LINKS) connection parameter only if you need to specify TCP/IP options. See CommLinks (LINKS) connection parameter.

If you know that a database server named sales is running on a computer called elora on the default port number, then you can use the following connection string to connect to the database server:

UID=DBA;PWD=sql;Server=sales;Host=elora:2638

If you do not know the port number that the database server is running on, use the following connection string to connect to the sales database server running on the computer named elora:

UID=DBA;PWD=sql;Server=sales;Host=elora

Host connection parameter

Syntax

Usage

Allowed values

Default

Remarks

Note

See also

Example