#include <iostream> 
using std::cin; 
using std::cout; 
using std::endl; 
#include <afxwin.h> 
#include <sql.h> 
#include <sqlext.h> 
void main() 
{ 
  // declarations needed for SQL 
  RETCODE rc;        // ODBC return code 
  HENV henv;         // Environment 
  HDBC hdbc;         // Connection handle 
  HSTMT hstmt;       // Statement handle 

  // attempt to connect to the ODBC database 
  char db[] = "myDatabase"; // ODBC database name 
  cout << "Attempting to open database " << db << "..." << endl; 
  SQLAllocEnv(&henv); 
  SQLAllocConnect(henv, &hdbc); 
  rc = SQLConnect(hdbc, (unsigned char*)db, SQL_NTS, 0, 0, 0, 0); 
  // if not successful, quit 
  if ((rc != SQL_SUCCESS) && (rc != SQL_SUCCESS_WITH_INFO)) 
  { 
    cout << "Cannot open database -- make sure ODBC is configured properly." << endl; 
    SQLFreeConnect(hdbc); 
    SQLFreeEnv(henv); 
    cout << "Press ENTER to continue." << endl; 
    cin.get(); 
    return; 
  } 
  // create another SQL statement 
  rc = SQLAllocStmt(hdbc, &hstmt); 
  sql = "SELECT desig,term,units,grade FROM courses"; 
  // execute the SQL statement 
  cout << "Executing " << sql << endl; 
  rc = SQLExecDirect(hstmt, (unsigned char*)sql, SQL_NTS); 
  if ((rc != SQL_SUCCESS) && (rc != SQL_SUCCESS_WITH_INFO)) 
  { 
    // error executing SQL statement 
    SQLCHAR sqlState[8], msgText[1024]; 
    SQLINTEGER NativeErrorPtr; 
    SQLSMALLINT TextLengthPtr; 
    SQLGetDiagRec(SQL_HANDLE_STMT, hstmt, 1, sqlState, 
      &NativeErrorPtr, msgText, sizeof(msgText), &TextLengthPtr); 
    SQLFreeStmt(hstmt, SQL_DROP); 
    SQLDisconnect(hdbc); 
    SQLFreeConnect(hdbc); 
    SQLFreeEnv(henv); 
    cout << "Error  " << endl << msgText << endl; 
    cout << "Press ENTER to continue." << endl; 
    cin.get(); 
    return; 
  } 
  // close database 
  SQLFreeStmt(hstmt, SQL_DROP); 
  SQLDisconnect(hdbc); 
  SQLFreeConnect(hdbc); 
  cout << "Finished. Press ENTER to continue." << endl; 
  cin.get(); 
}