examples/odbc/ODBCman2.c

   1 //  Connect to the Data source
   2 //  create table emp with 3 fields.
   3
   4 #include<stdio.h>
   5 #include<stdlib.h>
   6 #include<string.h>
   7 #include<sql.h>
   8 #include<sqlext.h>
   9
  10 inline void checkrc(int rc, int line)
  11 {
  12    if(rc)
  13    {
  14       printf("ERROR %d at line %d\n",rc,line);
  15       exit(1);
  16    }
  17 }
  18
  19
  20 int main()
  21 {
  22    SQLHENV env;
  23    SQLHDBC dbc;
  24    SQLHSTMT stmt;
  25    SQLRETURN ret;
  26    SQLCHAR outstr[1024];
  27    SQLSMALLINT  outstrlen;
  28
  29    ret = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
  30    checkrc(ret,__LINE__);
  31
  32    ret = SQLSetEnvAttr(env,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC3,0);
  33    checkrc(ret,__LINE__);
  34
  35    ret = SQLAllocHandle(SQL_HANDLE_DBC,env,&dbc);
  36    checkrc(ret,__LINE__);
  37
  38    ret = SQLConnect (dbc,
  39                    (SQLCHAR *) "test", (SQLSMALLINT) strlen ("test"),
  40                    (SQLCHAR *) "root",
  41                    (SQLSMALLINT) strlen ("root"),
  42                    (SQLCHAR *) "manager",
  43                    (SQLSMALLINT) strlen (""));
  44
  45
  46
  47
  48    if(SQL_SUCCEEDED(ret))
  49    {
  50       printf("\nConnect to the data source successfully\n");
  51    }
  52    else
  53    {
  54      printf("Failed to connect\n");
  55      return 2;
  56    }
  57
  58
  59    ret = SQLAllocHandle(SQL_HANDLE_STMT,dbc,&stmt);
  60    checkrc(ret,__LINE__);
  61
  62   // Table creation
  63    SQLCHAR table[100]= "create table emp(eid int, ename char(20),salary float)";
  64
  65    ret = SQLExecDirect(stmt,table,SQL_NTS);
  66    checkrc(ret,__LINE__);
  67    printf("Table 'emp' created \n");
  68
  69    ret = SQLFreeHandle(SQL_HANDLE_STMT,stmt);
  70    checkrc(ret,__LINE__);
  71
  72    ret - SQLDisconnect(dbc);
  73    checkrc(ret,__LINE__);
  74
  75    ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  76    checkrc(ret,__LINE__);
  77
  78    ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
  79    checkrc(ret,__LINE__);
  80    return 0;
  81 }
  82