test/odbc/Select/odbcselect8.c

   1 // call SQLExecute() without calling SQLPrepare().
   2 // it should fail.
   3
   4 // AUTHOR : Jitendra Lenka
   5
   6 #include<stdio.h>
   7 #include<sql.h>
   8 #include<stdlib.h>
   9 #include<sqlext.h>
  10 #include<string.h>
  11
  12 //*************************************************************************
  13
  14 inline void checkrc(int rc,int line)
  15 {
  16    if(rc)
  17    {
  18        printf("ERROR %d at line %d\n",rc,line);
  19        exit(1);
  20
  21    }
  22 }
  23
  24 //*************************************************************************
  25
  26 int main()
  27 {
  28   SQLHENV env;
  29   SQLHDBC dbc;
  30   SQLHSTMT stmt;
  31   SQLRETURN ret;
  32   SQLCHAR outstr[1024];
  33   SQLSMALLINT outstrlen;
  34
  35   // Aloocate an environment handle
  36   ret=SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&env);
  37   checkrc(ret,__LINE__);
  38
  39    //we need odbc3 support
  40    SQLSetEnvAttr(env,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC3,0);
  41
  42   //ALLOCATE A Connection handle
  43   ret = SQLAllocHandle(SQL_HANDLE_DBC,env,&dbc);
  44   checkrc(ret,__LINE__);
  45
  46   // connect to the DSN mydsn
  47    ret = SQLConnect (dbc,
  48                    (SQLCHAR *) "test", (SQLSMALLINT) strlen ("test"),
  49                    (SQLCHAR *) "root",
  50                    (SQLSMALLINT) strlen ("root"),
  51                    (SQLCHAR *) "manager",
  52                    (SQLSMALLINT) strlen (""));
  53
  54   if(SQL_SUCCEEDED(ret))
  55   {
  56      printf("\nConnected to the Data Source..\n");
  57
  58   }
  59    else
  60    {
  61         printf("error in connection\n");
  62
  63         ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  64         checkrc(ret,__LINE__);
  65
  66         ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
  67         checkrc(ret,__LINE__);
  68         return 1;
  69    }
  70
  71
  72    //******************************************************************
  73    // TABLE CREATED
  74    ret = SQLAllocHandle(SQL_HANDLE_STMT,dbc,&stmt);
  75    checkrc(ret,__LINE__);
  76
  77    SQLCHAR table[200]=
  78      "CREATE TABLE T1(F1 INT,F2 INT)";
  79   // ret = SQLPrepare(stmt,table,SQL_NTS);
  80 //   checkrc(ret,__LINE__);
  81    ret = SQLExecute(stmt);
  82    int rettype = ret;
  83    if(ret)
  84    printf("Table creation failed\n");
  85
  86    else
  87    printf("\nTABLE CREATED\n");
  88    //****************************************************************
  89
  90
  91    //****************************************************************
  92    ret = SQLFreeHandle(SQL_HANDLE_STMT,stmt);
  93    checkrc(ret,__LINE__);
  94
  95    ret = SQLDisconnect(dbc);
  96    checkrc(ret,__LINE__);
  97
  98    ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  99    checkrc(ret,__LINE__);
 100
 101    ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
 102    checkrc(ret,__LINE__);
 103
 104    if(rettype == 0)return 1;
 105
 106    return 0;
 107  }