Verifying that you can connect to servers

Use isql or dsedit to perform a quick test. Use isql to connect to servers:

  1. At the command prompt, enter:

    isql -Usa -Ppassword -Sserver_name
    

    where server_name is the Adaptive Server, Monitor Server, or Historical Server name.

    The command prompt is displayed if the login is successful.

  2. To display the Adaptive Server version number, enter:

    1> select @@version
    2> go
    

    Adaptive Server’s version number is displayed. The output should show Adaptive Server at version 12.5.

Alternatively, start dsedit.

  1. From the Windows task bar, select Start | Programs | Sybase | dsedit.

  2. Open the Directory Services window by clicking on OK.

  3. Highlight the servername, where servername is the name of the server you want to test.

  4. From the Server Option drop-down menu, select Ping.

  5. A successful connection returns the message that the connection succeeded.