> SQLAllocHandle (SQL_HANDLE_ENV, NULL, &henv);
> SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
> SQLConnect (hDBC, szDSN, SQL_NTS, szUID, SQL_NTS, szPasswd, SQL_NTS);
> SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
> while( i < 10){
> SQLPrepare(hstmt,(SQLCHAR*)szSql, SQL_NTS);
> SQLBindParameter(......);
> ......
Please could you send us the exact szSql and their BindParameters
so we don't have to make steps into dark? BTW table structure and
some sample data could help too.
It speeds up finding the problem.
> SQLExecute(hstmt);
> SQLFreeStmt(hstmt,SQL_RESET_PARAMS);
> }
> SQLEndTran(SQL_HANDLE_DBC,(SQLHDBC)hdbc, SQL_COMMIT);
> SQLFreeStmt(hstmt, SQL_CLOSE);
> SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
> SQLDisconnect(hdbc);
> SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
Regards,
Luf