CODEWITHSUNDEEP
c++mysqlsqlodbc
DoGoodDeeds
DoGoodDeeds

Reputation: 41

In ODBC, SQLExecute() returns SQL_NEED_DATA

SQLExecute() can be successfully executed without parameters, but with parameters it returns SQL_NEED_DATA. SQLPrepare() and SQLBindParameter() execute successfully.

ret = SQLAllocHandle(SQL_HANDLE_STMT, hDbc, &hStmt);
SQLSetStmtAttr(hStmt, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)3, 0); 
SQLCHAR* SQLToExe3 = (SQLCHAR*) "INSERT INTO student VALUES(?,?,?)" ;
ret = SQLPrepare(hStmt, SQLToExe3, SQL_NTS);

Test(ret); 
        
SQLCHAR SNOInput[SNO_Len]="2030211892", SNameInput[SName_Len]="zhangxun", SDepartInput[SDepart_Len]="CS";
    
SQLLEN SNOLen,SNameLen2,SDepartLen2;
ret = SQLBindParameter(hStmt, 1, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR, 20, 0, SNOInput, SNO_Len, &SNOLen);
ret = SQLBindParameter(hStmt, 2, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR, 20, 0, SNameInput, SName_Len, &SNameLen2);
ret = SQLBindParameter(hStmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR, 20, 0, SDepartInput, SNO_Len, &SDepartLen2);

ret = SQLExecute(hStmt);// SQLExecute return SQL_INVALID_HANDLE

Upvotes: 1

Views: 392

Answers (1)

DoGoodDeeds
DoGoodDeeds

Reputation: 41

SOLVED: Set the value of parameter StrLen_or_IndPtr of SQLBindParameter() to SQL_NTS

Upvotes: 1

Related Questions