version 2004
ODBC_SQLGetEnvAttr (attribute; value) Longint
| Parameter | Type | Description | |
| attribute | Longint | Attribute to retrieve | |
| value | Longint | Current value of the attribute | |
| Function result | Longint | Returns the result of the MS ODBC API function | |
| SQLGetEnvAttr |
Description
The ODBC_SQLGetEnvAttr command returns the current setting of an environment attribute.
attribute is the environment attribute to retrieve and can be one of the following values:
| Constant | Description |
| SQL_ATTR_CONNECTION_POOLING | Enables or disables connection pooling at the |
| environment level | |
| SQL_ATTR_CP_MATCH | Determines how a connection is chosen from a |
| connection pool | |
| SQL_ATTR_ODBC_VERSION | Determines whether certain functionality exhibits |
| ODBC 2.x behavior or ODBC 3.x behavior | |
| SQL_ATTR_OUTPUT_NTS | Determines how the driver returns string data |
value is the current value of attribute.
For more information, please see the SQLGetEnvAttr function in the MS ODBC API to http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlgetenvattr.asp.
Function Results
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NO_DATA, SQL_ERROR, or SQL_INVALID_HANDLE.
Example
The following method sets a environment attribute and then retrieves it:
$result:=ODBC_SQLSetEnvAttr (SQL_ATTR_ODBC_VERSION ;3) $result:=ODBC_SQLGetEnvAttr (SQL_ATTR_ODBC_VERSION ;vEnvAttribute)
See Also