Thread: Problem with SQLExecDirect

I've created a function which inserts into an ODBC database.
The statement executes without errors, but nothing is inserted into the database...

Code:

short DbConnection::Execute(char *strSql){
	short sRes(0);
	void *hStmt;

	if(this->m_isOpen=FALSE || SQLAllocHandle(SQL_HANDLE_STMT, this->m_hDbc, &hStmt)!=SQL_SUCCESS 
		|| SQLExecDirect(hStmt, (UCHAR*)strSql, SQL_NTS)!=SQL_SUCCESS
		|| SQLEndTran(SQL_HANDLE_DBC, this->m_hDbc, SQL_COMMIT)!=SQL_SUCCESS){
		this->errMsg(hStmt);
		sRes=0;
	}else 
		sRes=1;
	SQLFreeHandle(SQL_HANDLE_STMT, hStmt);
	return(sRes);
}

I tried tracing the ODBC-operarions, but it says that everything returns SQL_SUCCESS..
Any clues?

Figured it out, I'm an idiot, and queried the wrong DB...