Changing the server entries in sql.ini

To edit an existing sql.ini file on the server machine, or to create a new file on the client machine, use the Directory Services Editor utility, dsedit.

For more information about the components of a sql.ini file, see “Components in the sql.ini file”.

For more information about using dsedit, see theUtilties Guide.

For general information about the sql.ini file, see the Open Client/Server Configuration Guide for Desktop Platforms.

To start dsedit, select it either from the Sybase program group or from the Utilities group in Sybase Central.

To add an Adaptive Server to the sql.ini file:

  1. Select Start/Programs/Sybase/dsedit.

    The Select Directory Service dialog box appears.

  2. Select a driver from the DS Name list, and click OK.

    The DSEDIT - Interfaces Driver dialog box appears.

  3. Select Server Object menu, and select Add.

    The Input Server Name dialog box appears.

  4. Type the name of the server to add, and click OK.

    For information about valid server names, see “Server name”.

  5. Select the new server name, which you have just added, from the Server list.

    Steps 6 – 10 describe how to enter the server’s address:

  6. Select Server Address from Attributes box on the Interfaces Driver window.

  7. Select the Server Object menu and select Modify Attribute.

    The Network Address Attribute dialog box appears.

  8. Click Add.

    The Input Network Address For Protocol dialog box appears.

  9. Choose the appropriate protocol from the drop-down list, enter the network address in the Network Address text box, and click OK.

    For information about protocols, see “Network driver”.

    For information about the formats of network addresses required by the different protocols, see “Server address”.

    The Network Address Attribute dialog box reappears.

  10. Click OK.

    The dsedit utility creates MASTER and QUERY entries for the server. In the sql.ini file, the client ignores the MASTER entry.

  11. Exit dsedit.