4D Doc Center : ODBC_SQLSetEnvAttr

Home

4D v14.1

ODBC_SQLSetEnvAttr


ODBC_SQLSetEnvAttr ( attribute ; value ) -> Function result

Parameter	Type	Description
attribute	Longint	Attribute to set
value	Longint	Value to set the attribute
Function result	Longint	Returns the result of the MS ODBC API function SQLSetEnvAttr

The ODBC_SQLSetEnvAttr command sets an attribute that governs the different aspects of environments.

attribute is the environment attribute to set 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 a Longint value at which to set attribute.

For more information, please see the SQLSetEnvAttr function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms709285(VS.85).aspx.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

See the example for the ODBC_SQLGetEnvAttr command.