Is the property of the connection. property can be one of the following values.
Returns the physical transport protocol that is used by this connection. Is not nullable.
Return values are: HTTP, Named pipe, Session, Shared memory, SSL, TCP, and VIA.
Always returns Session when a connection has multiple active result sets (MARS) enabled, and connection pooling is enabled.
Returns the protocol type of the payload. It currently distinguishes between TDS (TSQL) and SOAP. Is nullable.
Returns the SQL Server Authentication scheme for a connection. The authentication scheme is either Windows Authentication (NTLM, KERBEROS, DIGEST, BASIC, NEGOTIATE) or SQL Server Authentication. Is not nullable.
Returns the IP address on the server that this connection targeted. Available only for connections that are using the TCP transport provider. Is nullable.
Returns the server TCP port that this connection targeted if the connection were a connection that is using the TCP transport. Is nullable.
Asks for the address of the client that is connecting to this server. Is nullable.
Returns the physical transport protocol that is used by this connection. Accurate when a connection has multiple active result sets (MARS) enabled.