Driver Attributes

The following table lists the C language #defines for the fInfoType argument and the corresponding values that are returned by SQLGetInfo when connected to SQL Server 6.x. An application retrieves this information by passing the listed C language #defines to SQLGetInfo in the fInfoType argument.

fInfoType argument (#define) Value returned by SQLGetInfo
SQL_ACCESSIBLE_PROCEDURES Y
SQL_ACCESSIBLE_TABLES Y
SQL_ACTIVE_CONNECTIONS 0 (The number of active connections is determined by the number of network connections available on the client computer and the number of connections allowed by the server DBMS.)
SQL_ACTIVE_STATEMENTS 1 (Even though this value is 1, the driver supports multiple active statements on a connection if server cursors are being used. For more information, see Using ODBC Cursors.)
SQL_ALTER_TABLE SQL_AT_ADD_COLUMN
SQL_BOOKMARK_PERSISTENCE 0
SQL_COLUMN_ALIAS Y
SQL_CONCAT_NULL_BEHAVIOR SQL_CB_NON_NULL
SQL_CONVERT_FUNCTIONS SQL_FN_CVT_CONVERT
SQL_CONVERT_type where type is
the SQL datatype, such as CHAR
For more information, see the Datatype Mapping_and_Usage topic.
SQL_CORRELATION_NAME SQL_CN_ANY
SQL_CURSOR_COMMIT_BEHAVIOR SQL_CB_CLOSE (This is the ANSI-specified behavior. Because many applications need to preserve server cursor currency across commits/rollbacks, the driver provides a driver-specific option, SQL_PRESERVE_CURSORS, to override the ANSI default.)
SQL_CURSOR_ROLLBACK
_BEHAVIOR
SQL_CB_CLOSE (This is the ANSI-specified behavior. Recognizing the need for many applications to preserve server cursor currency across commits/rollbacks, the driver provides a driver-specific option, SQL_PRESERVE_CURSORS, to override the ANSI default.)
SQL_DBMS_NAME Microsoft SQL Server
SQL_DEFAULT_TXN_ISOLATION SQL_TXN_READ_COMMITTED
SQL_DRIVER_NAME SQLSRVR.DLL (16-bit)
SQLSRV32.DLL (32-bit)
SQL_DRIVER_ODBC_VER 02.50
SQL_DRIVER_VER 02.65.nnnn (where nnnn specifies the build number)
SQL_EXPRESSIONS_IN_ORDERBY Y
SQL_FETCH_DIRECTION SQL_FD_FETCH_NEXT
SQL_FD_FETCH_FIRST
SQL_FD_FETCH_LAST
SQL_FD_FETCH_PRIOR
SQL_FD_FETCH_ABSOLUTE
SQL_FD_FETCH_RELATIVE
SQL_FD_FETCH_BOOKMARK
SQL_FILE_USAGE SQL_FILE_NOT_SUPPORTED
SQL_GETDATA_EXTENSIONS SQL_GD_BLOCK
SQL_GROUP_BY SQL_GB_GROUP_BY_CONTAINS
_SELECT
SQL_IDENTIFIER_CASE (Depends on whether SQL Server was installed as case-sensitive or case-insensitive.)
SQL_IDENTIFIER_QUOTE_CHAR " (Double quote)
SQL_KEYWORDS BREAK
BROWSE
BULK
CHECKPOINT
CLUSTERED
COMMITTED
COMPUTE
CONFIRM
CONTROLROW
DATABASE
DBCC
DISK
DUMMY
DUMP
ERRLVL
ERROREXIT
EXIT
EXPIREDATE
FILE
FILLFACTOR
FLOPPY
GETDEFAULT
HOLDLOCK
IDENTITY_INSERT
IDENTITYCOL
IF
KILL
LINENO
LOAD
MIRROREXIT
NONCLUSTERED
OFF
OFFSETS
ONCE
OVER
PERM
PERMANENT
PLAN
PRINT
PROC
PROCESSEXIT
PUBLIC
RAISERROR
READ
READTEXT
RECONFIGURE
REPEATABLE
RETAINDATE
RETURN
ROWCOUNT
RULE
SAVE
SERIALIZABLE
SETUSER
SHUTDOWN
STATISTICS
TAPE
TEMP
TEXTSIZE
TRAN
TRIGGER
TRUNCATE
TSEQUEL
UNCOMMITTED
UPDATETEXT
USE
VOLUME
WAITFOR
WHILE
WRITETEXT
SQL_LIKE_ESCAPE_CLAUSE Y
SQL_LOCK_TYPES SQL_LCK_NO_CHANGE
SQL_MAX_BINARY_LITERAL_LEN 131072
SQL_MAX_CHAR_LITERAL_LEN 131072
SQL_MAX_COLUMN_NAME_LEN 30
SQL_MAX_COLUMNS_IN_GROUP

_BY

16
SQL_MAX_COLUMNS_IN_INDEX 16
SQL_MAX_COLUMNS_IN_ORDER
_BY
16
SQL_MAX_COLUMNS_IN_SELECT 4000
SQL_MAX_COLUMNS_IN_TABLE 250
SQL_MAX_CURSOR_NAME_LEN 30
SQL_MAX_INDEX_SIZE 900
SQL_MAX_OWNER_NAME_LEN 30
SQL_MAX_PROCEDURE_NAME
_LEN
36 (1 to 30 characters followed by a semicolon [;] and one to five digits)
SQL_MAX_QUALIFIER_NAME_LEN 30
SQL_MAX_ROW_SIZE 1962
SQL_MAX_ROW_SIZE_INCLUDES
_LONG
N
SQL_MAX_STATEMENT_LEN 131072
SQL_MAX_TABLE_NAME_LEN 30
SQL_MAX_TABLES_IN_SELECT 16
SQL_MAX_USER_NAME_LEN 30
SQL_MULT_RESULT_SETS Y
SQL_MULTIPLE_ACTIVE_TXN Y
SQL_NEED_LONG_DATA_LEN Y
SQL_NON_NULLABLE_COLUMNS SQL_NNC_NON_NULL
SQL_NULL_COLLATION SQL_NC_LOW
SQL_NUMERIC_FUNCTIONS SQL_FN_NUM_ABS
SQL_FN_NUM_ACOS
SQL_FN_NUM_ASIN
SQL_FN_NUM_ATAN
SQL_FN_NUM_ATAN2
SQL_FN_NUM_CEILING
SQL_FN_NUM_COS
SQL_FN_NUM_COT
SQL_FN_NUM_DEGREES
SQL_FN_NUM_EXP
SQL_FN_NUM_FLOOR
SQL_FN_NUM_LOG
SQL_FN_NUM_LOG10
SQL_FN_NUM_MOD
SQL_FN_NUM_PI
SQL_FN_NUM_POWER
SQL_FN_NUM_RADIANS
SQL_FN_NUM_RAND
SQL_FN_NUM_ROUND
SQL_FN_NUM_SIGN
SQL_FN_NUM_SIN
SQL_FN_NUM_SQRT
SQL_FN_NUM_TAN
SQL_ODBC_API_CONFORMANCE SQL_OAC_LEVEL2
SQL_ODBC_SAG_CLI
_CONFORMANCE
SQL_OSCC_NOT_COMPLIANT
SQL_ODBC_SQL_CONFORMANCE SQL_OSC_CORE
SQL_ODBC_SQL_OPT_IEF Y
SQL_ORDER_BY_COLUMNS_IN
_SELECT
N
SQL_OJ_CAPABILITIES SQL_OJ_LEFT
SQL_OJ_RIGHT
SQL_OJ_FULL
SQL_OJ_NESTED
SQL_OJ_NOT_ORDERED
SQL_OJ_INNER
SQL_OJ_ALL_COMPARISON_OPS
SQL_OUTER_JOINS Y
SQL_OWNER_TERM owner
SQL_OWNER_USAGE SQL_OU_DML_STATEMENTS
SQL_OU_PROCEDURE_INVOCATION
SQL_OU_TABLE_DEFINITION
SQL_OU_INDEX_DEFINITION
SQL_OU_PRIVILEGE_DEFINITION
SQL_POS_OPERATIONS SQL_POS_ADD
SQL_POS_DELETE
SQL_POS_POSITION
SQL_POS_REFRESH
SQL_POS_UPDATE
SQL_POSITIONED_STATEMENTS SQL_PS_POSITIONED_DELETE
SQL_PS_POSITIONED_UPDATE
SQL_PS_SELECT_FOR_UPDATE
SQL_PROCEDURE_TERM stored procedure
SQL_PROCEDURES Y
SQL_QUALIFIER_LOCATION SQL_QL_START
SQL_QUALIFIER_NAME
_SEPARATOR
. (period)
SQL_QUALIFIER_TERM database
SQL_QUALIFIER_USAGE SQL_QU_DML_STATEMENTS
SQL_QU_PROCEDURE_INVOCATION
SQL_QU_TABLE_DEFINITION
SQL_QUOTED_IDENTIFIER_CASE (Depends on whether SQL Server was installed as case-sensitive or case-insensitive.)
SQL_ROW_UPDATES N
SQL_SCROLL_CONCURRENCY SQL_SCCO_LOCK
SQL_SCCO_OPT_ROWVER
SQL_SCCO_OPT_VALUES
SQL_SCCO_READ_ONLY
SQL_SCROLL_OPTIONS SQL_SO_DYNAMIC
SQL_SO_FORWARD_ONLY
SQL_SO_KEYSET_DRIVEN
SQL_SO_STATIC
SQL_SEARCH_PATTERN_ESCAPE \ (backslash)
SQL_SPECIAL_CHARACTERS #$ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔ
ÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïð
ñòóôõöøùúûüýþÿ
SQL_STATIC_SENSITIVITY SQL_SS_ADDITIONS
SQL_SS_UPDATES
SQL_STRING_FUNCTIONS SQL_FN_STR_ASCII
SQL_FN_STR_CHAR
SQL_FN_STR_CONCAT
SQL_FN_STR_DIFFERENCE
SQL_FN_STR_INSERT
SQL_FN_STR_LCASE
SQL_FN_STR_LEFT
SQL_FN_STR_LENGTH
SQL_FN_STR_LOCATE_2
SQL_FN_STR_LTRIM
SQL_FN_STR_REPEAT
SQL_FN_STR_RIGHT
SQL_FN_STR_RTRIM
SQL_FN_STR_SOUNDEX
SQL_FN_STR_SPACE
SQL_FN_STR_SUBSTRING
SQL_FN_STR_UCASE
SQL_SUBQUERIES SQL_SQ_COMPARISON SQL_SQ_EXISTS
SQL_SQ_IN
SQL_SQ_QUANTIFIED
SQL_SQ_CORRELATED
_SUBQUERIES
SQL_SYSTEM_FUNCTIONS SQL_FN_SYS_DBNAME
SQL_FN_SYS_IFNULL
SQL_FN_SYS_USERNAME
SQL_TABLE_TERM table
SQL_TIMEDATE_ADD_INTERVALS SQL_FN_TSI_FRAC_SECOND
SQL_FN_TSI_SECOND
SQL_FN_TSI_MINUTE
SQL_FN_TSI_HOUR
SQL_FN_TSI_DAY
SQL_FN_TSI_WEEK
SQL_FN_TSI_MONTH
SQL_FN_TSI_QUARTER SQL_FN_TSI_YEAR
SQL_TIMEDATE_DIFF_INTERVALS SQL_FN_TSI_FRAC_SECOND
SQL_FN_TSI_SECOND
SQL_FN_TSI_MINUTE
SQL_FN_TSI_HOUR
SQL_FN_TSI_DAY
SQL_FN_TSI_WEEK
SQL_FN_TSI_MONTH
SQL_FN_TSI_QUARTER
SQL_FN_TSI_YEAR
SQL_TIMEDATE_FUNCTIONS SQL_FN_TD_NOW
SQL_FN_TD_CURDATE
SQL_FN_TD_DAYOFMONTH
SQL_FN_TD_DAYOFWEEK
SQL_FN_TD_DAYOFYEAR
SQL_FN_TD_DAYNAME
SQL_FN_TD_MONTH
SQL_FN_TD_MONTHNAME
SQL_FN_TD_QUARTER
SQL_FN_TD_WEEK
SQL_FN_TD_YEAR
SQL_FN_TD_CURTIME
SQL_FN_TD_HOUR
SQL_FN_TD_MINUTE
SQL_FN_TD_SECOND
SQL_FN_TD_TIMESTAMPADD
SQL_FN_TD_TIMESTAMPDIFF
SQL_TXN_CAPABLE SQL_TC_ALL
SQL_TXN_ISOLATION_OPTION SQL_TXN_READ_COMMITTED
SQL_TXN_READ_UNCOMMITTED
SQL_TXN_REPEATABLE_READ
SQL_TXN_SERIALIZABLE
SQL_UNION SQL_U_UNION
SQL_U_UNION_ALL

The ODBC SQL Server driver supports the following new driver-specific SQLGetInfo value:

fInfoType parameter rgbInfoValue returned
SQL_INFO_SS_NETLIB_NAME The name of the Net-Library DLL that is used to connect to SQL Server.

(Similar to dbprocinfo.)