Development Process

Figure 1 ODBC-based application development process

APIs Involved in the Development Process

Table 1 API description

Function	API
Allocate a handle	SQLAllocHandle is a generic function for allocating a handle. It can replace the following functions: SQLAllocEnv: allocate an environment handle SQLAllocConnect: allocate a connection handle SQLAllocStmt: allocate a statement handle
Set environment attributes	SQLSetEnvAttr
Set connection attributes	SQLSetConnectAttr
Set statement attributes	SQLSetStmtAttr
Connect to a data source	SQLConnect
Bind a buffer to a column in the result set	SQLBindCol
Bind the parameter marker of an SQL statement to a buffer	SQLBindParameter
Return the error message of the last operation	SQLGetDiagRec
Prepare an SQL statement for execution	SQLPrepare
Run a prepared SQL statement	SQLExecute
Run an SQL statement directly	SQLExecDirect
Fetch the next row (or rows) from the result set	SQLFetch
Return data in a column of the result set	SQLGetData
Get the column information from a result set	SQLColAttribute
Disconnect from a data source	SQLDisconnect
Release a handle	SQLFreeHandle is a generic function for releasing a handle. It can replace the following functions: SQLFreeEnv: release an environment handle SQLFreeConnect: release a connection handle SQLFreeStmt: release a statement handle

NOTE:
If an execution request (not in a transaction block) received in the database contains multiple statements, the request is packed into a transaction. If one of the statements fails, the entire request will be rolled back.