How to Connect to SAP Adaptive Server

Connect to an ASE Server

The connection dialog is explained here.
Tip Firewalls & anti-viruses may block database connections. Read How to enable Firewall connections.

Enabling the TCP/IP Port

For all editions of SAP Adaptive Server Enterprise:
  1. From the SAP Adaptive Server Configuration Manager, select SAP Adaptive Server Network Configuration in the left panel and navigate to the Sybase Adaptive Server instance.
  2. The right panel displays all protocols for the specified SAP Adaptive Server instance and their status.
  3. Ensure that TCP/IP is enabled.
  4. (If TCP/IP is disabled), right-click TCP/IP and select Properties. The TCP/IP Properties dialog box appears.
  5. In the Protocol tab, select enabled, and click Apply.
  6. Restart the SAP Adaptive Server instance.

Finding the TCP/IP Port

To find the TCP/IP port number for a particular SAP Adaptive Server instance, run the following query:
Select address_info from syslisteners
The above query returns the host address followed by the port number.

Debug Connectivity Issues

  1. Check Network:
    From the machine where DbSchema is running execute:
    ping HOST_NAME
    If this is failing it means the host name is wrong. In this case look on how to find the server host name as described in Connect to SqlServer.
  2. Check if the port is open.
    To verify that SQL Server listening port, you can use the telnet from the computer where you run DbSchema. If not installed, you can install Telnet like this:
    1. Click Start > Control Panel.
    2. Click Programs and Features.
    3. Click Turn Windows features on or off.
    4. In the Windows Features dialog box, check the Telnet Client check box.
    5. Click OK. The system installs the appropriate files. This will take a few seconds to a minute.
    Assume that SQL Server's IP address is 192.168.1.1 or host name 'samplehost', port 11433, you can run the following command:
    telnet 192.168.1.1 1433
    or
    telnet samplehost 1433
        
    If the TELNET successful, then the result will be a only a black screen with cursor in flash. If unsuccessful, then you will get an error message. In this case please the port may be wrong. Please How to enable TCP/IP connections regarding on how to see the configured TCP/IP port.
  3. Check On Server the Port value and TCP/IP to be enabled
    Read the chapter How to enable TCP/IP connections. There you will find also instructions about finding the configured TCP/IP port.
  4. Create an exception for SQL Server in Windows Firewall:
    Follow the steps from the Firewall chapter.
  5. Enable the SQL Server Browser service:
    If you connect to a named instance, make sure the SQL Server Browser service by using SQL Server Configuration Manager is enable or specify the TCP port when connecting to it.