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 using dsedit, see the Utilities 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 SAP ASE program group or from the Utilities group in SAP Control Central.

  1. Select Start > Programs > SAP > Connectivity > Open Client Directory Service Editor.
  2. Select a driver from the DS Name list, and click OK.
  3. Select Server Object menu, and select Add.
  4. Enter the name of the server to add, and click OK.
  5. Select the new server name, which you have just added, from the Server list.
  6. Enter the server's address:
    1. Select Server Address from the Attributes box on the Interfaces Driver window.
    2. Select Server Object > Modify Attribute.
    3. Click Add.
    4. Choose the appropriate protocol, enter the network address, and click OK.
  7. Click OK.

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

  8. Exit dsedit.