Case study 22: How to connect to Sybase ASE server when its name is not known?
  • Platform: HP-UNIX 11, Tru64 , Windows
  • Sybase ASE version: 12.5.x, 15.x
  • Background story: From time to time, I've found myself remotely connected to system which is unknown for me, with several Sybase ASE instances on one machine, with several interfaces files. And I have a problem connecting to desired server.
  • Task: Find out how to connect to Sybase ASE server which name is not known.
  • Solution: I've found solution for my problem in one of the isql options. It is H option(representing Host name), which allows me to connect to desired Sybase ASE server only by knowing on which port Sybase ASE is listening and machine name. If Sybase ASE runs on machine named europe on port 12400, it can be reached with following command:

    isql -Heurope,12400 -Uuser_name -Ppassword -Ddatabase_name

    In this way, I do not have to think which isql I am using, but I am sure that I will connect to desired Sybase.
   
  powered by myself. DBA-Sybase 2006