4D v13

ODBC_SQLGetEnvAttr

Home

 
4D v13
ODBC_SQLGetEnvAttr

ODBC_SQLGetEnvAttr 


 

ODBC_SQLGetEnvAttr ( attribute ; value ) -> Function result 
Parameter Type   Description
attribute  Longint in Attribute to retrieve
value  Longint in Current value of the attribute
Function result  Longint in 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:

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 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.

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)

 
PROPERTIES 

Product: 4D
Theme: ODBC_Driver attributes
Number: 16983

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLSetEnvAttr