To connect to our database over a WIFI or VPN connection I need to specify a Port Number. This worked fine until I rebooted the server last night and the Port on which the database was listening has changed.
Is there a way I can specify a Port Number that should always be used?
We are running SQL Anywhere 9.0, no option to upgrade.
asked 14 Sep '16, 06:53
You can specify the port number the server should use with the PORT protocol option, such as
or even specify a range of ports of which the server should use all those that are available:
Likewise, the client can explicitly use a specified port (or a port range, of which then the first available is used) in the PORT protocol option of the LINKS connection parameters:
For details, see that FAQ .
You could try running the dblocate utility (dblocate ip-address).
Example: dblocate 10.7.161.42
However, I must confess that version 9 of this tool crashed on me (version 9 is very ancient software).
answered 15 Sep '16, 10:55