|
|
|
|
|
|
|
|
|
version 2004
ODBC_SQLSetConnectAttr (connectionID; attribute; valuePtr) 
Longint
| 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 |
Description
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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlsetconnectattr.asp.
Function Results
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.
Example
See the example for the ODBC_SQLGetConnectAttr command.
See Also
|
|
|
|
|
|
|
|
|