Return SQL Server-Specific Types as ODBC Types

This option specifies whether the connector returns the SQL Server-specific data types that are listed in the table below as ODBC data types, or as SQL Server data types.

  • Enabled (yes, true, or 1) yes, true, or 1: The connector returns the data types listed below as ODBC data types.
  • Disabled (no, false, or 0) no, false, or 0: The connector returns the data types listed below as SQL Server data types.
SQL Server Type Returned ODBC Type

TDS_SQL_SS_TIME

SQL_TYPE_TIME

TDS_SQL_SS_DATETIMEOFFSET

SQL_WVARCHAR

Key Name Default Value Required

ReturnSpecificType
AsOdbcType

Clear (no) no

No