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