4D Doc Center : ODBC_SQLSetConnectAttr

4D v13

ODBC_SQLSetConnectAttr


ODBC_SQLSetConnectAttr ( connectionID ; attribute ; valuePtr ) -> Function result

Parameter	Type	Description
connectionID	Longint	Connection ID
attribute	Longint	Attribute to set
valuePtr	Pointer	Pointer to the value to set the attribute
Function result	Longint	Returns the result of the MS ODBC API function SQLSetConnectAttr

The ODBC_SQLSetConnectAttr command sets the attributes that govern aspects of connections.

connectionID is a valid connection ID returned by either ODBC_SQLAllocConnect before or ODBC_SQLConnect after having established a connection to a data source depending on attribute.

attribute is a connection attribute to set and can be one of the following values:

Constant	Description
SQL_ATTR_ACCESS_MODE*	Read-only or read-write
SQL_ATTR_ASYNC_ENABLE	Defines if a function can be executed asynchronously
SQL_ATTR_AUTOCOMMIT*	Autocommit or manual-commit mode
SQL_ATTR_CONNECTION_TIMEOUT	Number of seconds to wait for a request to complete
SQL_ATTR_CURRENT_CATALOG	Name of the catalog to be used by the data source
SQL_ATTR_LOGIN_TIMEOUT*	Number of seconds to wait for a login request
SQL_ATTR_METADATA_ID	Determines how the string arguments of catalog functions are treated
SQL_ATTR_ODBC_CURSORS*	Specifies how the Driver Manager uses the ODBC cursor
SQL_ATTR_PACKET_SIZE	Network packet size in bytes
SQL_ATTR_QUIET_MODE	Does not display any dialog boxes, except ODBC_SQLDriverConnect
SQL_ATTR_TRACE*	Tracing on or off
SQL_ATTR_TRACEFILE*	Name of the trace file
SQL_ATTR_TRANSLATE_LIB	Name of a library containing to perform tasks, such as character set translation
SQL_ATTR_TRANSLATE_OPTION**	A value passed to the trnaslation DLL
SQL_ATTR_TXN_ISOLATION	Set the transaction isolation level for connection

Notes:
* These attributes must be set before a connection is established.
** This attribute must be set after connecting.

valuePtr is a pointer to a variable containing the value at which to set the attribute parameter.

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

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

See the example for the ODBC_SQLGetConnectAttr command.