The value specified for the argument ParameterType was neither a valid ODBC SQL data type identifier nor a driver-specific SQL data type identifier supported by the driver. The value specified by the argument ValueType was not a valid C data type or SQL_C_DEFAULT. The driver was unable to allocate memory that is required to support execution or completion of the function. The error message returned by SQLGetDiagRec in the * MessageText buffer describes the error and its cause. (DM) The value specified for the argument ParameterNumber was less than 1.Īn error occurred for which there was no specific SQLSTATE and for which no implementation-specific SQLSTATE was defined. Notice that this error may be returned by SQLExecDirect, SQLExecute, or SQLPutData at execution time, instead of by SQLBindParameter. The data type identified by the ValueType argument cannot be converted to the data type identified by the ParameterType argument. (Function returns SQL_SUCCESS_WITH_INFO.) SQLSTATEĭriver-specific informational message. The return code associated with each SQLSTATE value is SQL_ERROR, unless noted otherwise. The following table lists the SQLSTATE values typically returned by SQLBindParameter and explains each one in the context of this function the notation "(DM)" precedes the descriptions of SQLSTATEs returned by the Driver Manager. When SQLBindParameter returns SQL_ERROR or SQL_SUCCESS_WITH_INFO, an associated SQLSTATE value can be obtained by calling SQLGetDiagRec with a HandleType of SQL_HANDLE_STMT and a Handle of StatementHandle. SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE. For more information, see " StrLen_or_IndPtr Argument" in "Comments." Returns A pointer to a buffer for the parameter's length. See ODBC 64-Bit Information, if your application will run on a 64-bit operating system. For more information, see " BufferLength Argument" in "Comments." Length of the ParameterValuePtr buffer in bytes. For more information, see " ParameterValuePtr Argument" in "Comments." A pointer to a buffer for the parameter's data. For more information about column size, see Column Size, Decimal Digits, Transfer Octet Length, and Display Size. The decimal digits of the column or expression of the corresponding parameter marker. If your application will run on a 64-bit Windows operating system, see ODBC 64-Bit Information. For more information, see " ColumnSize Argument" in "Comments." The size of the column or expression of the corresponding parameter marker. For more information, see " ParameterType Argument" in "Comments." For more information, see " ValueType Argument" in "Comments." For more information, see " InputOutputType Argument" in "Comments." Parameter number, ordered sequentially in increasing parameter order, starting at 1. For more information, see "Comments." Syntax This function replaces the ODBC 1.0 function SQLSetParam.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |