Skip to content

DF_DATABASE_ODBC_DRIVER_NAME

The name of the used database ODBC driver.

Level

Database

Supported by

The DataFlex SQL Drivers (SQL Server, DB2, and ODBC), revision 23 and higher.

Type

String, temporary.

Access

Read Only.

Values

0..

Syntax

Use cli.pkg
Get_Attribute DF_DATABASE_ODBC_DRIVER_NAME of {driverNumber} {databaseHandle} to {StringVariable}

Driver Configuration Keyword

None.

Remarks

The DF_DATABASE_ODBC_DRIVER_NAME returns the name of the ODBC driver used to connect to a SQL database.

Installed ODBC drivers can be seen in the ODBC Data Source Administrator on the “Drivers” tab page.

Examples

“ODBC Driver 17 for SQL Server”
“PostgreSQL Unicode(x64)”
“MySQL ODBC 8.0 Ansi Driver”
“MariaDB ODBC 3.1 Driver”

All DataFlex SQL Drivers (MSSQLDRV, ODBC_DRV, DB2_DRV) will return a value for this attribute.

The DF_DATABASE_ODBC_DRIVER_NAME attribute will only return a value when connected to a database.

The DF_DATABASE_ODBC_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