test/odbc/Adapter/odbcconnect5c.c

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