Full text search
function	SQLSetConnectAttr

Library: ODBC Include: omodbc.xin

Returns: Numeric An SQL return code. The following values may be returned: SQL_SUCCESS (the connection attributes were successfully set). SQL_SUCCESS_WITH_INFO (the connection attributes were successfully set, but a message was issued). SQL_ERROR (an error occurred). SQL_INVALID_HANDLE (the handle is invalid).

Declaration

  define external counter function SQLSetConnectAttr
     (  read-only SQL_handle_type ConnectionHandle,
        value counter Attribute,
        read-only SQL_vector_type Value,
        value counter StringLength,
        value counter ValueType )

Sets attributes that govern aspects of connections.

Input arguments:

1. ConnectionHandle.
2. Attribute. The attribute identifier. The following values are allowed:
   • SQL_ATTR_AUTO_IPD
   • SQL_ATTR_METADATA_ID
   • SQL_ATTR_ASYNC_ENABLE
   • SQL_ATTR_ACCESS_MODE
   • SQL_ATTR_AUTOCOMMIT
   • SQL_ATTR_CONNECTION_TIMEOUT
   • SQL_ATTR_CURRENT_CATALOG
   • SQL_ATTR_LOGIN_TIMEOUT
   • SQL_ATTR_ODBC_CURSORS
   • SQL_ATTR_PACKET_SIZE
   • SQL_ATTR_QUIET_MODE
   • SQL_ATTR_TRACE
   • SQL_ATTR_TRACEFILE
   • SQL_ATTR_TRANSLATE_LIB
   • SQL_ATTR_TRANSLATE_OPTION
   • SQL_ATTR_TXN_ISOLATION
3. Value. The value to be associated with Attribute.
4. StringLength. The size of Value.
5. ValueType. The type of data specified in Value. The following values are allowed: SQL_CHAR and SQL_INTEGER.