ODBC deprecated commands

This table lists the ODBC deprecated commands:
Command Options Description
odbc sqlallocconnect
  • henv
  • hdbc
Allocates memory for a connection handle within the specified environment. This also sets the variable specified in hdbc to the new connection handle.
odbc sqlallocenv henv Allocates memory for an environment handle and initializes the ODBC API for use by an application. An application must invoke odbc sqlallocenv before invoking any other odbc function. This also sets the variable specified in henv to the new environment handle.
odbc sqlallocstmt
  • hdbc
  • hstmt
Allocates memory for a statement handle and associates the statement handle with the connection specified by hdbc. This also sets the variable specified in hstmt to the new statement handle.
odbc sqlcolattribute
  • hstmt
  • icol
  • fDescType
  • rgbDesc
  • cbDescMax
  • pcbDesc
  • pfDesc
Supplies descriptive information for a column in a result set.
odbc sqlerror
  • henv
  • hdbc
  • hstmt
  • szSqlState
  • pfNativeError
  • szErrorMsg
  • cbErrorMsgMax
  • pcbErrorMsg
Supplies error or status information.
odbc sqlextendedfetch
  • hstmt
  • fFetchType
  • irow
  • pcrow
  • rgfRowStatus
Extends the functionality of SQLFetch. Retrieves multiple rows and returns them in arrays.
odbc sqlfreeconnect hdbc Releases a connection handle and frees all memory that is associated with the handle.
odbc sqlfreeenv henv Frees the environment handle and releases all memory that is associated with the environment handle.
odbc sqlgetconnectoption
  • hdbc
  • fOption
  • pvParam
Supplies the current setting of a connection option.
odbc sqlgetstmtoption
  • hstmt
  • fOption
  • pvParam
Supplies the current setting of a statement option.
odbc sqlparamoptions
  • hstmt
  • crow
  • pirow
Specifies multiple values for the set of parameters that are assigned by SQLBindParameter.
odbc sqlsetconnectoption
  • hdbc
  • fOption
  • vParam
Sets options which govern aspects of connections.
odbc sqlsetparam
  • hstmt
  • ipar
  • fCType
  • fSqlType
  • cbColDef
  • ibScale
  • rgbValue
  • pcbValue
This ODBC 1.0 function has been replaced by the ODBC 2.0 function SQLBindParameter.
odbc sqlsetscrolloptions
  • hstmt
  • fConcurrency crowKeyset
  • crowRowset
Sets options that control the behavior of cursors that are associated with an hstmt.
odbc sqlsetstmtoption
  • hstmt
  • fOption
  • vParam
Sets options that are related to an hstmt.
odbc sqltransact
  • henv
  • hdbc
  • fType
Requests a commit or rollback operation for:
  • All active operations on all hstmt that are associated with connection hdbc.

    or

  • All active operations on all hstmt for all connections in henv.