test/odbc/Adapter/odbcconnect2c.c

   1 //    sqlconnect,sqldisconnect and then again call sqlconnect.it should pass.
   2 //    connect to the DATA SOURCE with the connection string "DSN=mycsql;MODE=ADAPTER;SERVER=localhost;PORT=5678;"
   3 //    see retrieving ODBC Diagnostics
   4
   5 #include<stdio.h>
   6 #include<stdlib.h>
   7 #include<sql.h>
   8 #include<sqlext.h>
   9 #include<string.h>
  10
  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 *) "DSN=mycsql;MODE=ADAPTER;SERVER=localhost;PORT=5678;", (SQLSMALLINT) strlen ("DSN=mycsql;MODE=ADAPTER;SERVER=localhost;PORT=5678;"),
  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 successfully..\n");
  56
  57   }
  58    else
  59    {
  60         printf("connection failed\n");
  61
  62         ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  63         checkrc(ret,__LINE__);
  64
  65         ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
  66         checkrc(ret,__LINE__);
  67
  68         return 1;
  69    }
  70
  71    ret = SQLDisconnect(dbc);
  72    checkrc(ret,__LINE__);
  73    printf("Disconnected from the Datasource\n");
  74    //**************************************************************************************************
  75    // again sqlconnect
  76
  77
  78
  79
  80    ret =   SQLConnect (dbc,
  81                    (SQLCHAR *) "DSN=mycsql;MODE=ADAPTER;SERVER=localhost;PORT=5678;", (SQLSMALLINT) strlen ("DSN=mycsql;MODE=ADAPTER;SERVER=localhost;PORT=5678;"),
  82                    (SQLCHAR *) "root",
  83                    (SQLSMALLINT) strlen ("root"),
  84                    (SQLCHAR *) "manager",
  85                    (SQLSMALLINT) strlen (""));
  86
  87    int rettype =ret;
  88
  89   if(SQL_SUCCEEDED(ret))
  90   {
  91      printf("Again Connected to the Data Source successfully..\n");
  92
  93
  94   }
  95    else
  96    {
  97         printf("connection failed\n");
  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         return 1;
 106    }
 107
 108    ret = SQLDisconnect(dbc);
 109    checkrc(ret,__LINE__);
 110
 111    //**************************************************************************************************
 112    ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
 113    checkrc(ret,__LINE__);
 114
 115    ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
 116    checkrc(ret,__LINE__);
 117    if(rettype !=0)return 1;
 118    return 0;
 119 }