4D v13

ODBC_SQLSetConnectAttr

Home

 
4D v13
ODBC_SQLSetConnectAttr

ODBC_SQLSetConnectAttr 


 

ODBC_SQLSetConnectAttr ( connectionID ; attribute ; valuePtr ) -> Function result 
Parameter Type   Description
connectionID  Longint in Connection ID
attribute  Longint in Attribute to set
valuePtr  Pointer in Pointer to the value to set the attribute
Function result  Longint in 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:

ConstantDescription
SQL_ATTR_ACCESS_MODE*Read-only or read-write
SQL_ATTR_ASYNC_ENABLEDefines if a function can be executed asynchronously
SQL_ATTR_AUTOCOMMIT*Autocommit or manual-commit mode
SQL_ATTR_CONNECTION_TIMEOUTNumber of seconds to wait for a request to complete
SQL_ATTR_CURRENT_CATALOGName 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_IDDetermines 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_SIZENetwork packet size in bytes
SQL_ATTR_QUIET_MODEDoes 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_LIBName 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_ISOLATIONSet 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.

Example  

See the example for the ODBC_SQLGetConnectAttr command.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Driver attributes
Number: 16981

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLGetConnectAttr