I am new to using Sybase (MS SQL guy). I have installed Sybase central on of my machines and i would like to access a DB on that from a client application on a different machine from a different network. Unfortunately it is not as easy as with MS SQL as to just open a port and allowing TCP connections. I would really appreciate if one of you can point me in the right direction.
Thanks a bunch in advance!
Connection to a SQL Anywhere server can be quite easy, and you can connect to a server knowing its host and port if you are using a more recent version of SA (v12 and up).
If you have started your database server on host myHost like this:
where X is 12 or 16 and P is your choice for port number, example:
then you can connect to this server using the connection string: