I'm starting a sqla11 setup at a new customer site.
The customer wants to know which ports to open.
I replied 2638 and 49152.
He then asked if those ports will carry both tcp and udp traffic.
I replied 'both tcp and udp.'
However, after googling the subject, I'm not sure if udp is necessary.

What is the function of udp traffic and is it necessary?
Am I correct that sqla11 ip traffic is normally both tcp and udp?

Thanks,
Doug

The default port used by SQL Anywhere is 2638. If this port number is in
use, then the server picks an unused port, beginning at 49152, and
listens on that. (Note that 49152 is not reserved for use by SA, while
2638 is.)

The default connection mechanism uses UDP to find the server and then
TCP to connect to it. However, you can bypass the UDP discovery using
the the Host and DoBroadcast TCP parameters in your client's connection
string / DSN. For example:

Links=tcpip
-- will broadcast for the server using UDP

Links=tcpip(host=foo)
-- will attempt to connect via TCP to a server on host "foo". If the
connection fails, we will broadcast for the server using UDP.

Links=tcpip(host=foo;DoBroadcast=none)
-- will attempt to connect via TCP to a server on host "foo". If the
connection fails, we will not broadcast.

If you always use Host and DoBroadcast=None in your connection strings,
SA will not use UDP at all.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


Doug Stone wrote: