DF_DRIVER_SQLSERVER_CLIENT_VERSION

The SQL Client version in use.

Level

Driver

Supported by

ODBC and MSSQLDRV, revision 5 and higher

Type

Integer, temporary

Access

Read

Values

This attribute can return the following values:

SQLSERVERUNKNOWNCLIENT (0)   // unknown
SQLSERVER2000CLIENT (8)      // "SQL Server"
SQLSERVER2005CLIENT (9)      // "SQL Native Client"
SQLSERVER2008CLIENT (10)     // "SQL Server Native Client 10.0"
SQLSERVER2012CLIENT (11)     // "SQL Server Native Client 11.0"
SQLSERVER2014CLIENT (12)     // "ODBC Driver 11 for SQL Server"
SQLSERVER2016CLIENT (13)     // "ODBC Driver 13 for SQL Server"
SQLSERVER2017CLIENT (17)     // "ODBC Driver 17 for SQL Server"
SQLSERVER2018CLIENT (18)     // "ODBC Driver 18 for SQL Server"

Syntax

Use cli.pkg
Get_Attribute DF_DRIVER_SQLSERVER_CLIENT of {driverNumber} to {IntegerVariable}

Driver Configuration Keyword

None

Remarks

The driver can be configured to raise an error if the client and server version do not match. See DF_DRIVER_MATCH_CLIENT_SERVER_VERSION.