examples/odbc/ODBCman1.c

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