Driver
The DataFlex SQL Drivers (SQL Server, DB2 and ODBC), revision 6.2.0.28 and higher
Integer, temporary
Read Only
For SQL Server, the minimum client version can be set to:
8: SQL Server (SQL Server 2000 client)
9: SQL Native Client (SQL Server 2005 client)
10: SQL Server Native Client 10.0 (SQL Server 2008 client)
11: SQL Server Native Client 11.0 (SQL Server 2012 client)
12: ODBC Driver 11 for SQL Server (SQL Server 2014 client)
13: ODBC Driver 13 for SQL Server (SQL Server 2016 client)
17: ODBC Driver 17 for SQL Server (SQL Server 2017 client)
18: ODBC Driver 18 for SQL Server (SQL Server 2019 client)
For MSSQLDRV, the default value is 10: SQL Server Native Client 10.0 (SQL Server 2008 client).
For DB2_DRV and ODBC_DRV, the default value is 0.
Use cli.pkg
Get_Attribute DF_DRIVER_MINIMUM_CLIENT_VERSION of {driverNumber} to {IntegerVariable}
MINIMUM_CLIENT_VERSION
In general it is best to use matching client and server versions. For this, the DF_Driver_Match_Client_Server_Version attribute can be used.
Using older client with newer server versions may sometimes cause unpredictable results.
A known issue is when using SQL Server date type. This type was introduced in SQL Server 2008 and is not recognized by older clients. An older client will return SQL dates as string (DF_Ascii), which can cause incorrect date values in the database.
SQL Database Drivers Client Usage