Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere as an Open Server » Configuring Open Servers

Adding a server entry Next Page

Adding or changing the server address

Once you have entered a Server Name, you need to modify the Server Address to complete the interfaces file entry.

To enter a Server Address
  1. Select a server entry in the Server box.

  2. Right-click the Server Address in the Attributes box.

  3. Choose Modify Attribute from the popup menu. A window appears, showing the current value of the address. If you have no address entered, the box is empty.

    The Network Address Attribute window, showing the Protocol Network Address box where the server address appears.
  4. Click Add.

    The Input Network Address for Protocol window appears.

  5. Select NLWNSCK from the Protocol dropdown list (this is the TCP/IP protocol) and enter a value in the Network Address field.

    The Input Network Address for Protocol dialog showing the network address for the NLWNSCK protocol.

    For TCP/IP addresses, use one of the following two forms:

    The address or computer name is separated from the port number by a comma.

Machine name

A name (or an IP address) identifies the computer on which the server is running. On Windows operating systems, you can find the computer name in Network Settings, in the Control Panel.

If your client and server are on the same computer, you must still enter the computer name. In this case, you can use localhost to identify the current computer.

Port number

The port number you enter must match the port number you used to start the SQL Anywhere database server with. See Starting the database server as an Open Server.

The default port number for SQL Anywhere servers is 2638. This number has been assigned to SQL Anywhere by the Internet Adapter Number Authority (IANA), and use of this port is recommended unless you have good reasons for explicitly using another port.

The following are valid server address entries: