ODBC_SQLGetEnvAttr

4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next

version 2004


ODBC_SQLGetEnvAttr (attribute; value) Longint

ParameterTypeDescription
attributeLongintAttribute to retrieve
valueLongintCurrent value of the attribute
Function resultLongintReturns 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:

ConstantDescription
SQL_ATTR_CONNECTION_POOLINGEnables or disables connection pooling at the
environment level
SQL_ATTR_CP_MATCHDetermines how a connection is chosen from a
connection pool
SQL_ATTR_ODBC_VERSIONDetermines whether certain functionality exhibits
ODBC 2.x behavior or ODBC 3.x behavior
SQL_ATTR_OUTPUT_NTSDetermines 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

ODBC_SQLSetEnvAttr.


4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next