4D v16

ODBC_SQLSetConnectAttr

Accueil

 
4D v16
ODBC_SQLSetConnectAttr

ODBC_SQLSetConnectAttr 


 

ODBC_SQLSetConnectAttr ( connectionID ; attribute ; valuePtr ) -> Résultat 
Paramètre Type   Description
connectionID  Entier long in Connection ID
attribute  Entier long in Attribute to set
valuePtr  Pointeur in Pointer to the value to set the attribute
Résultat  Entier long 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.

Exemple  

See the example for the ODBC_SQLGetConnectAttr command.



Voir aussi  

ODBC_SQLGetConnectAttr

 
PROPRIÉTÉS 

Produit : 4D
Thème : ODBC_Driver attributes
Numéro : 16981
Nom intl. : ODBC_SQLSetConnectAttr

 
HISTORIQUE 

Créé : 4D ODBC Pro 2004

 
UTILISATION DE L'ARTICLE

4D ODBC Pro ( 4D v16)