test/odbc/Connect/odbcconnect5.c

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