DoBroadcast (DOBROAD) protocol option

Controls how a client searches for a database server, and controls whether the database server broadcasts when it starts.

{ DoBroadcast | DOBROAD }= { YES | NO }

{ DoBroadcast | DOBROAD }= { ALL | NONE | DIRECT }

YES Setting DoBroadcast=YES allows the database server to broadcast to find other database servers with the same name when it starts.
NO Setting DoBroadcast=NO prevents the database server from broadcasting to find other database servers with the same name when starting up. This is useful in certain rare circumstances, but it is not generally recommended.

ALL With DoBroadcast=ALL a broadcast is performed to search for a database server. The broadcast goes first to the local subnet. If HOST is specified, broadcast packets are also sent to each of the hosts. All broadcast packets are UDP packets.
NONE Specifying DoBroadcast=NONE causes no UDP broadcasts to be used, and the database server address cache (located in the sasrv.ini file) is ignored. A TCP/IP connection is made directly with the HOST/PORT specified, and the database server name is verified. If you specify DoBroadcast=NONE, the HOST (IP) protocol option is required.
DIRECT With DoBroadcast=DIRECT, no broadcast is performed to the local subnet to search for a database server. Broadcast packets are sent only to the hosts listed in the HOST (IP) protocol option. If you specify DoBroadcast=DIRECT, the HOST (IP) protocol option is required.

Client usage With TCP/IP, you can choose not to verify the database server name by setting the VerifyServerName (VERIFY) protocol option to NO. The HOST (IP) protocol option is a required parameter, unless LDAP is being used, while the ServerPort (PORT) protocol option is optional.
For DIRECT and NONE, you must specify the database server host with the HOST option.

The following connection string fragment connects to a database server named gold running on the computer named silver.

Host=silver;ServerName=gold

The following connection string fragment uses the CommLinks protocol option to connect to the same database server.

CommLinks=tcpip(DOBROADCAST=DIRECT;HOST=silver);ServerName=gold

Discuss this page in DocCommentXchange.