on 2013 May 05 11:51 AM
Hello,
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:
dbsrvX -n myServer myDatabase.db -x tcpip{port=P}
where X is 12 or 16 and P is your choice for port number, example:
dbsrv16 -n myServer myDatabase.db -x tcpip{port=2638}
then you can connect to this server using the connection string:
-c serverName=myServer;dbn=myDatabase;host=myHost:2638
Take a look at the documentation for more information on connection strings and common connection scenarios.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.