test/odbc/Connect/odbcconnect4.c

   1 // close the connction and then call prepare,
   2 // it should failed
   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 //*************************************************************************
  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 int main()
  25 {
  26   SQLHENV env;
  27   SQLHDBC dbc;
  28   SQLHSTMT stmt;
  29   SQLRETURN ret;
  30   SQLCHAR outstr[1024];
  31   SQLSMALLINT outstrlen;
  32
  33   // Aloocate an environment handle
  34   ret=SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&env);
  35   checkrc(ret,__LINE__);
  36
  37    //we need odbc3 support
  38    SQLSetEnvAttr(env,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC3,0);
  39
  40   //ALLOCATE A Connection handle
  41   ret = SQLAllocHandle(SQL_HANDLE_DBC,env,&dbc);
  42   checkrc(ret,__LINE__);
  43
  44   // connect to the DSN mydsn
  45    ret = SQLConnect (dbc,
  46                    (SQLCHAR *) "test", (SQLSMALLINT) strlen ("test"),
  47                    (SQLCHAR *) "root",
  48                    (SQLSMALLINT) strlen ("root"),
  49                    (SQLCHAR *) "manager",
  50                    (SQLSMALLINT) strlen (""));
  51
  52
  53   if(SQL_SUCCEEDED(ret))
  54   {
  55      printf("\nConnected to the Data Source..\n");
  56
  57
  58   }
  59    else
  60    {
  61         printf("conenction failed\n");
  62         ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  63         checkrc(ret,__LINE__);
  64
  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
  76    ret = SQLDisconnect(dbc);
  77    checkrc(ret,__LINE__);
  78
  79    //AFTER CLOSE THE CONNECTION ,CALL PREPARE
  80    ret = SQLPrepare(stmt,table,SQL_NTS);
  81    int rettype = ret;
  82    if(ret!=SQL_SUCCESS && ret !=SQL_SUCCESS_WITH_INFO)
  83    printf("After closing the connection, prepare failed \n");
  84
  85
  86
  87    ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  88    checkrc(ret,__LINE__);
  89
  90    ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
  91    checkrc(ret,__LINE__);
  92    if(rettype == 0)
  93    {
  94     printf("Test script failed\n");
  95     return 1;
  96    }
  97
  98   return 0;
  99 }