C / C++ / MFC

how do you incorporate the GUI in C++? 

Hi C++ Gurus, 

Below code is generating error code -2. Its working fine for sql queries like "select * from emp", but where as in Insert statement its returning error code.  Please help.

Regards,
Suresh

#include "database.h"

int main(){

SQLRETURN ret = 0; /* ODBC API return status */

SQLHENV env;
SQLHDBC dbc;
SQLHSTMT stmt;

SQLSMALLINT msg_len = 0;
SQLCHAR sql_state[6], message[256];
SQLINTEGER native_error = 0;

try{
    ret = SQLAllocEnv(&env);
    ret = SQLAllocConnect(env, &dbc);
    ret = SQLConnect(dbc, (SQLCHAR*)"KarTarDB", strlen("KarTarDB"), (SQLCHAR*)"sa",2,(SQLCHAR*)"KarTarPwd",9);

    if(ret == SQL_INVALID_HANDLE || ret < 0) {
        cout << "Connection open failure." << endl;
        ret = SQLGetDiagRec(SQL_HANDLE_STMT, stmt, 1, sql_state, &native_error, message, sizeof(message), &msg_len);
        cout << ret << endl;
    } else{
        char sql[100]="INSERT INTO emp(name, age, dob) VALUES ('john', 23, '010101')";

        ret = SQLPrepare(stmt,(unsigned char*)sql, SQL_NTS);//strlen(sql));
        ret = SQLExecute(stmt);//,(SQLCHAR*)sql,strlen(sql));

        if(ret == SQL_ERROR || ret < 0) {
            cout << "ResultSet Error: " << ret << endl;
            //ret = SQLGetDiagRec(SQL_HANDLE_STMT, stmt, 1, sql_state, &native_error, message, sizeof(message), &msg_len);
        }else{
            cout << "Done" << endl;
        }
    }
}catch(...) {
    cout << "Database error.." << endl;
    }
return 0;
}