The CS_CONNECTION structure defines a connection from a client application to a remote server. Applications use the CS_CONNECTION structure to define Client-Library behavior at the connection level, and to store and retrieve information about a connection:
CS_CONNECTION properties customize connection behavior. For example, an application can set the CS_TDS_VERSION connection property to request that a connection use a certain Tabular Data Stream (TDS) protocol version.
A CS_CONNECTION inherits message and error handlers from its parent context, but an application can override these default handlers by installing new ones.
The Client-Library CS_CONNECTION structure has several advantages over the DB-Library DBPROCESS:
Message and error handlers can be installed on a per-connection basis.
Login information is bound to the connection: Login parameters become read-only properties after the connection is established.
A Client-Library connection can simultaneously support an active cursor and another command.
