Force communication over port

[Former Member]

Is there a way to force the whole sql communication over one specific port?

[Chris_Kleisath · Accepted solution]

You can specify the PORT number when you start the server. For example:

dbsrv12 -x tcpip(ServerPort=2629) -n server3 c:\\mydata.db

After doing this, you then need to specify the port when you issue client connections, for example:

dbisql -c "UID=DBA;PWD=sql;ServerName=server3;Host=serverhost3:2629"

You can read more about this option on DCX: http://dcx.sybase.com/index.html#1201/en/dbadmin/serverport-network-conparm.html

[MCMartin · Accepted solution]

With MyIP=192.75.209.12 inside the tcpip() you can also control which of the multiple IP adresses of the server is used by the database server.