Errors and ODBC Conformance
Because the DB Interface Module does not simulate behavior that is not provided in the ODBC API and ODBC SQL grammar, certain functions of the DB Interface Module are reported as errors using the error code RWDBStatus::notSupported. For example, there is no ODBC grammar that generally supports the idea of an RWDBDatabase::createProcedure() function, so it is reported as “not supported.”
There is a much broader range of possible errors that depend entirely on the underlying ODBC driver in use. Errors of this sort are most likely to occur during the execution of advanced SQL via a call to SQLExecute(). These errors are reported using the error code RWDBStatus::serverError.
SourcePro DB makes no attempt to mitigate against such errors, but when an error does occur, information is transferred to DB Interface Module objects as described below.