test/odbc/Gateway/odbcconnect3f.c

   1 //   Connect the DATA SOURCE with the connection string "DSN=mycsql;MODE=GATEWAY;SERVER=127.0.0.1;PORT=5678;"
   2 //   close the connection and then call commit,it should fail.
   3
   4 #include<stdio.h>
   5 #include<stdlib.h>
   6 #include<sql.h>
   7 #include<sqlext.h>
   8 #include<string.h>
   9
  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=GATEWAY;SERVER=127.0.0.1;PORT=5678;", (SQLSMALLINT) strlen ("DSN=mycsql;MODE=127.0.0.1;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   }
  59    else
  60    {
  61         printf("error in connection\n");
  62
  63         ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  64         checkrc(ret,__LINE__);
  65
  66         ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
  67         checkrc(ret,__LINE__);
  68
  69         return 1;
  70    }
  71
  72    ret = SQLDisconnect(dbc);
  73    checkrc(ret,__LINE__);
  74    // call to commit
  75    ret = SQLTransact(env,dbc,SQL_COMMIT);
  76
  77    int rettype = ret;
  78
  79    if(ret)
  80
  81       printf("After disconnect,commit failed\n");
  82    else
  83    printf("After disconenct, commit passed\n");
  84
  85    ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  86    checkrc(ret,__LINE__);
  87
  88    ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
  89    checkrc(ret,__LINE__);
  90    if (rettype == 0) return 1;
  91    return 0;
  92 }