test/odbc/Select/odbcselect5nw.c

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