602SQL Documentation Index  

Client Communication Properties

Searching for Active SQL Servers

Windows

If the Permanent scanning when client is not connected checkbox is checked, then the 602SQL Client addresses registered 602SQL servers (using the UDP protocol) when it's not connected to a registered server or an ODBC data source, and refreshes the icons in the server list in the Control Panel according to their reactions.

If the Search for unregistered SQL servers in the network segment checkbox is checked, then the client interface searches the whole local segment for any running SQL servers running on the standard port 5001 if such servers are not registered. If a server is found, a running server tag and the name based on the IP address will be displayed in the server list in the Control panel.

More information about network communication may be found on the TCP/IP and Ports when using the TCP/IP communication page.

Both these activities may be evaluated by the network security components or local firewalls as potentially dangerous. You need to disable them for all clients in this case.

Linux

Only the Search for unregistered SQL servers in the network segment checkbox is active. The functionality of the first checkbox is compensated by the Refresh Control panel action.

Notification from Server

SQL statements over a record set, data import and export, and other mass operations may display the count of already processed records in the client status bar. You may also setup the frequency of number displaying. If the Receive notifications during long operations checkbox is not set (or equals 0) no numbers will be displayed (notifications are not received at all), if the value equals N, every Nth number will be displayed.

Notification receiving slows network communication between a client and a server thus slowing work. Notifications however offer information about the progress of long operations.

You may setup server notifications also with the Set_progress_report_modulus function.