How to connect to Sybase Server/Database without port number using DSN or RapidSQL? Or how to find port number?

sap-ase dsn isql rapidsql
Pritesh picture Pritesh · Sep 10, 2012 · Viewed 11.9k times · Source

I have Some Sybase Server/Databases. I know 1. Server Name 2. Database Name 3. Username 4. Password. Using this I can connect using ISQL but while using RapidSQL it asks for port. I have existing application which uses DSN, while creating DSN also it asks for port. I am looking for 2 possiblies using RapidSQL/Creating DSN without port or How to find port mumber?

I do not have SQL.ini file.

enter image description here

Answer

HumayunM picture HumayunM · Sep 13, 2012

Try this:

  1. Go to start-> RUN -> type dsedit. There will be a mneu "Select Directory Services"
  2. Click ok on InterfacesDriver.
  3. Highlight your server name on the left pane.

You will see its IP/Hostname and Port number on the right pane.

Related questions

From a Sybase Database, how I can get table description ( field names and types)?

I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that? Thanks.

Read More
How do I find out what version of Sybase is running

I would like to know the exact version of Sybase currently running on my machine. Please let me know how to get this info?

Read More
list all tables from a database in syBase

In sql server 2012 i'm using USE myDatabase; GO SELECT * FROM sys.objects WHERE type = 'U'; Is it possible to do the same in syBase ?

Read More