test/odbc/Gateway/odbcconnect7e.c

   1 //  Use Connection String "DSN=mycsql;MODE=GATEWAY;SERVER=localhost;PORT=5678;" for Connect Data Source
   2 //  SQLConnect, again call SQLConnect.
   3 //  second SQLConnect should return "connection name in use".
   4
   5
   6 #include<stdio.h>
   7 #include<stdlib.h>
   8 #include<sql.h>
   9 #include<sqlext.h>
  10 #include<string.h>
  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 Data source
  45    ret = SQLConnect (dbc,
  46                    (SQLCHAR *) "DSN=mycsql;MODE=GATEWAY;SERVER=localhost;PORT=5678;", (SQLSMALLINT) strlen ("DSN=mycsql;MODE=GATEWAY;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..\n");
  56
  57   }
  58
  59
  60    else
  61    {
  62         printf("error in connection\n");
  63         ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  64         checkrc(ret,__LINE__);
  65
  66         ret = SQLFreeHandle(SQL_HANDLE_DBC,env);
  67         checkrc(ret,__LINE__);
  68         return 1;
  69    }
  70    //*********************************************************************
  71    //again call to driver connect
  72
  73    ret = SQLConnect (dbc,
  74                    (SQLCHAR *) "DSN=mycsql;MODE=GATEWAY;SERVER=localhost;PORT=5678;", (SQLSMALLINT) strlen ("DSN=mycsql;MODE=GATEWAY;SERVER=localhost;PORT=5678;"),
  75                    (SQLCHAR *) "root",
  76                    (SQLSMALLINT) strlen ("root"),
  77                    (SQLCHAR *) "manager",
  78                    (SQLSMALLINT) strlen (""));
  79
  80    int rettype = ret;
  81
  82   if(SQL_SUCCEEDED(ret))
  83   {
  84      printf("\nConnected to the Data Source..\n");
  85
  86
  87    }
  88
  89
  90    else
  91    {
  92         printf("Connection name  in use\n");
  93     }
  94
  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    if(rettype ==0)return 1;
 105    return 0;
 106 }