The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
22.3k9129262

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
22.3k9129262
accept rate: 40%

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:

×123
×97
×8

question asked: 05 May '13, 10:51

question was seen: 2,657 times

last updated: 07 May '13, 21:54