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!

asked 05 May '13, 10:51

SyDev's gravatar image

SyDev
61123
accept rate: 0%

edited 05 May '13, 17:13

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297

What database version are you using? ... and please confirm that you are using SQL Anywhere and not ASE!

(05 May '13, 17:15) Mark Culp

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.

permanent link

answered 05 May '13, 17:28

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297
accept rate: 41%

edited 05 May '13, 17:29

Thanks Mark! I am using SQL Anywhere 12, running on a windows 2008 server. I am trying to access it from a windows machine (A test application in Visual Studio 2012 running on Windows 7 64 bit machine).

Still unable to connect the DB a t this point.

(07 May '13, 15:48) SyDev
Replies hidden

Without more details on how you try to connect (i.e. what's the connection string? What API are you using - ODBC/ADO/ADO.Net/JDBC/...?) it's difficult to give more advice. - E.g. can you connect via an ODBC DSN (by testing the connection in the according 32-bit/64-bit ODMC administrator)?

(07 May '13, 17:00) Volker Barth

Check for firewalls since they can get in the way. You should check the server machine and the client machine firewalls rules - Windows firewall and possibly others that might be install on the computers (e.g. McAfee & Symantec has firewall software that often stop outgoing connections).

(07 May '13, 21:54) Mark Culp
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×159
×128
×9

question asked: 05 May '13, 10:51

question was seen: 5,811 times

last updated: 07 May '13, 21:54