Connecting to a server on a network – Sybase 12.4.2 User Manual

Page 80

Advertising
background image

Simple connection examples

60

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

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
.

Specifying the
protocol

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

Advertising