4D Doc Center : ODBC_SQLGetEnvAttr

Home

4D v14.1

ODBC_SQLGetEnvAttr


ODBC_SQLGetEnvAttr ( attribute ; value ) -> Function result

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

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 Reference to http://msdn.microsoft.com/en-us/library/ms709276(VS.85).aspx.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NO_DATA, SQL_ERROR, or SQL_INVALID_HANDLE.

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)