Troubleshooting
Problem
This technote provides the details on how to use the Sybase® SQLAnywhere 'DoBroadcast' communication parameter on the client/server sites.
Resolving The Problem
The SQL Anywhere client by default uses the broadcast packets to discover the IP address of the server. If the client and server are on different network segments, it's unlikely that a connection can be established. Below are the details on how to use the DoBroadcast communication parameter on the client/server sites.
DoBroadcast communication parameter [DOBROAD]
Usage
TCP/IP (all platforms)
SPX (all platforms except UNIX and CE)
Values
ALL, NONE, DIRECT (Client side)
YES, NO (Server side)
Default
ALL
Description
Client usage
With
DoBroadcast=ALL
(formerly
DoBroadcast=YES
) a broadcast is performed to search for a server. The broadcast goes first to the local subnet. If
HOST=
is specified, broadcast packets are also sent to each of the hosts. For TCP, all broadcast packets are UDP packets. For SPX, the broadcast is only performed if the server is not found in the bindery. For SPX, all broadcast packets are IPX packets.
With
DoBroadcast=DIRECT
(formerly
DoBroadcast=NO
), 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) communication parameter. If you specify
DoBroadcast=DIRECT
, the HOST (IP) communication parameter is required.
Specifying
DoBroadcast=NONE
causes no UDP or IPX broadcasts to be used. A TCP/IP or SPX connection is made directly with the HOST/PORT specified, and the engine name is verified. With TCP/IP, you can choose not to verify the engine name by setting the VerifyServerName (VERIFY) communication parameter to NO. The HOST (IP) communication parameter is a required parameter, while the ServerPort (PORT) communication parameter is optional.
For DIRECT and NONE, you must specify the server host with the HOST option.
Example
The following command connects to the server without UDP or IPX broadcasts to be used.
Host=ServerName;DOBROADCAST=NONE
Server usage
Setting
DoBroadcast=NO
prevents the database server from broadcasting to find other servers with the same name. This is useful in certain rare circumstances, but it is not generally recommended.
Example
The following command starts a client without broadcasting to search for a database server.
-n SQL_Server -tl 0 -ti 0 -x TCPIP{DOBROADCAST=NO} -gd all
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21226109