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

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