CHAPTER 2 Running Adaptive Server IQ

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.

79

Page 99
Image 99
Sybase 12.4.2 manual Assembling a list of connection parameters, Connection file, Parameter