Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 80 / 536

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