Sybase 12.4.2 manual Connecting to a server on a network

Simple connection examples

Connecting to a server on a network

To connect to a database running on a network server somewhere on a local or wide area network, the client software must be able to locate the database server. Adaptive Server IQ provides a network library (a DLL or shared library) that handles this task.

Network connections occur over a network protocol. Several protocols are supported, including TCP/IP, IPX, and NetBIOS.

Specifying the server

Specifying the protocol

Adaptive Server IQ server names are unique on a local domain for a given network protocol. The following connection parameters provide a simple example for connecting to a server running elsewhere on a network:

eng=svr_name dbn=db_name uid=user_id pwd=password

CommLinks=all

The client library first looks for a local server of the given name, and then looks on the network for a server of the specified name.

The above example finds any server started using the default port number. However, you can start servers using other port numbers by providing more information in the CommLinks parameter. For information on this parameter, see Chapter 3, “Connection and Communication Parameters” in Adaptive Server IQ Reference Manual.

If several protocols are available, you can tell the network library which ones to use. The following parameters use only the TCP/IP protocol:

eng=svr_name dbn=db_name uid=user_id pwd=password

CommLinks=tcpip

60