test/odbc/Select/odbcselect5.c

   1 //  select from non-existing table it should fail
   2
   3 //  AUTHOR : Jitendra lenka
   4
   5 #include<stdio.h>
   6 #include<stdlib.h>
   7 #include<sql.h>
   8 #include<sqlext.h>
   9 #include<string.h>
  10
  11 inline  void checkrc(int rc, int line)
  12 {
  13    if(rc)
  14    {
  15       printf("ERROR %d at line %d\n",rc,line);
  16       exit(1);
  17    }
  18 }
  19 //**********************************************************************************
  20
  21 int main()
  22 {
  23    SQLHENV  env;
  24    SQLHDBC  dbc;
  25    SQLHSTMT stmt;
  26    SQLRETURN ret;
  27    SQLCHAR outstr[1024];
  28    SQLSMALLINT  outstrlen;
  29
  30    ret = SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&env);
  31    checkrc(ret,__LINE__);
  32
  33    ret = SQLSetEnvAttr(env,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC3,0);
  34    checkrc(ret,__LINE__);
  35
  36    ret = SQLAllocHandle(SQL_HANDLE_DBC,env,&dbc);
  37    checkrc(ret,__LINE__);
  38
  39    ret = SQLConnect (dbc,
  40                    (SQLCHAR *) "test", (SQLSMALLINT) strlen ("test"),
  41                    (SQLCHAR *) "root",
  42                    (SQLSMALLINT) strlen ("root"),
  43                    (SQLCHAR *) "manager",
  44                    (SQLSMALLINT) strlen (""));
  45
  46   if(SQL_SUCCEEDED(ret))
  47    {
  48        printf("Connected to the data source successfully..\n");
  49
  50    }
  51
  52    else
  53     {
  54           printf("error in connection\n");
  55
  56          ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  57          checkrc(ret,__LINE__);
  58
  59          ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
  60          checkrc(ret,__LINE__);
  61          return 1;
  62     }
  63
  64      ret = SQLAllocHandle(SQL_HANDLE_STMT,dbc,&stmt);
  65      checkrc(ret,__LINE__);
  66
  67      ret = SQLPrepare(stmt,(unsigned char*)"SELECT * FROM EMP",SQL_NTS);
  68
  69
  70      ret = SQLExecute(stmt);
  71
  72      if(ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO)
  73      printf("Could not SQL Execute\n");
  74      int rettype = ret;
  75
  76
  77
  78      ret = SQLFreeHandle(SQL_HANDLE_STMT,stmt);
  79      checkrc(ret,__LINE__);
  80
  81      ret = SQLDisconnect(dbc);
  82      checkrc(ret,__LINE__);
  83
  84      ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  85      checkrc(ret,__LINE__);
  86
  87      ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
  88      checkrc(ret,__LINE__);
  89      if(rettype == 0)
  90      {
  91        printf("test script failed\n");
  92        return 1;
  93      }
  94      else
  95        printf("Test script passed\n");
  96      return 0;
  97
  98 }
  99
 100
 101
 102
 103
 104
 105