test/odbc/Select/odbcselect8nw.c

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