Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 99 / 536

CHAPTER 2 Running Adaptive Server IQ
79
Assembling a list of connection parameters
The following figure illustrates how the interface libraries assemble the list of
connection parameters they will use to establish a connection.
Notes Key points from the figure are as follows:
• Precedence — Parameters held in more than one place are subject to the
following order of precedence:
Connection string > SQLCONNECT > profile
That is, if a parameter is supplied both in a data source and in a connection
string, the connection string value overrides the data source value.
• Failure — Failure at this stage occurs only if you specify in the connection
string or in SQLCONNECT a data source that does not exist in the client
connection file.
• Common parameters — Depending on other connections already in use,
some connection parameters may be ignored. These include the following:
• AutoStop Ignored if the database is already loaded.
• CommLinks The specifications for a network protocol are ignored if
another connection has already set parameters for that protocol.
• CommBufferSize Ignored if another connection has already set this
parameter.