16.15 Attributes that can be specified in SQLSetEnvAttr and SQLGetEnvAttr

The following table lists and describes the attributes that can be specified in SQLSetEnvAttr and SQLGetEnvAttr.

Table 16‒20: Attributes that can be specified in SQLSetEnvAttr and SQLGetEnvAttr
No.	Attribute	Description (convention)	Support status	Data type
1	`SQL_ATTR_CONNECTION_POOLING`	Connection pool settings at an environment level.	This attribute is not supported.	--
2	`SQL_ATTR_CP_MATCH`	How to select a connection from a connection pool.	This attribute is not supported.	--
3	`SQL_ATTR_ODBC_VERSION`	The ODBC version that the driver complies with. `SQL_OV_ODBC3` The driver manager and driver have ODBC 3.0 behaviors as follows: The driver returns ODBC 3.0 codes for date, time, and time stamp and assumes ODBC 3.0 codes. When `SQLGetDiagField` or `SQLGetDiagRec` is called, the driver returns ODBC 3.0 `SQLSTATE` code. `SQL_OV_ODBC2` The driver manager and driver have ODBC 2.x behaviors as follows: The driver returns ODBC 2.x codes for dates, times, and time stamps, and assumes ODBC 2.x codes. When `SQLGetDiagField` or `SQLGetDiagRec` is called, the driver returns ODBC 2.x `SQLSTATE` codes. An application must set this environment attribute before calling a function that specifies an argument of type `SQLHENV`.	Supports the following value: `SQL_OV_ODBC3` `SQL_OV_ODBC2`	`SQLUINTEGER`
4	`SQL_ATTR_OUTPUT_NTS`	How the driver returns character string data. `SQL_TRUE` The driver returns null terminating character string data.	Supports the following value: `SQL_TRUE`	`SQLUINTEGER`