Skip to content

DF_DRIVER_SQLSERVER_CLIENT_DRIVER_NAME

The highest installed SQL Server client driver version.

Level

Driver

Supported by

DataFlex SQL Server Driver (MSSQLDRV), revision 23 and higher

Type

String, temporary

Access

Read

Values

This attribute can return the following values:

"SQL Server"
"SQL Native Client"
"SQL Server Native Client 10.0"
"SQL Server Native Client 11.0"
"ODBC Driver 11 for SQL Server"
"ODBC Driver 13 for SQL Server"
"ODBC Driver 17 for SQL Server"
"ODBC Driver 18 for SQL Server"

Syntax

Use mssqldrv.pkg
Get_Attribute DF_DRIVER_SQLSERVER_CLIENT_DRIVER_NAME of {driverNumber} to {StringVariable}

Driver Configuration Keyword

None

Remarks

The DF_DRIVER_SQLSERVER_CLIENT_DRIVER_NAME returns the name of the SQL Server driver that will be used by MSSQLDRV.

If multiple SQL Server client drivers are installed, the highest client version will be returned.

The DF_DRIVER_SQLSERVER_CLIENT_DRIVER_NAME attribute cannot be set.

Example

Use mssqldrv.pkg

Function MssqlClientDriverName Returns String
    Handle hoMsqlDrv
    Integer iDriver
    Integer iClientVersion
    String sClientDriverName

    Get Create (RefClass(cMSSQLHandler)) to hoMsqlDrv
    Get DriverIndex of hoMsqlDrv "MSSQLDRV" to iDriver

    If (iDriver > 0) Begin
        Get_Attribute DF_DRIVER_SQLSERVER_CLIENT_DRIVER_NAME of iDriver to sClientDriverName
    End

    Function_Return sClientDriverName
End_Function

See Also