test/odbc/Connect/odbcconnect1g.c

   1 //       connect to the DATA SOURCE with the connection string
   2 //       DSN=mycsql;MODE=csql;SERVER=localhost;NO PORT
   3 //       disconnect from the data source. It Should connect in embedded mode
   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
  15 inline void checkrc(int rc,int line)
  16 {
  17    if(rc)
  18    {
  19        printf("ERROR %d at line %d\n",rc,line);
  20        exit(1);
  21    }
  22 }
  23
  24 //*************************************************************************
  25 int main()
  26 {
  27   SQLHENV env;
  28   SQLHDBC dbc;
  29   SQLHSTMT stmt;
  30   SQLRETURN ret;
  31   SQLCHAR outstr[1024];
  32   SQLSMALLINT outstrlen;
  33
  34   // Aloocate an environment handle
  35   ret=SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&env);
  36   checkrc(ret,__LINE__);
  37
  38    //we need odbc3 support
  39    SQLSetEnvAttr(env,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC3,0);
  40
  41   //ALLOCATE A Connection handle
  42   ret = SQLAllocHandle(SQL_HANDLE_DBC,env,&dbc);
  43   checkrc(ret,__LINE__);
  44
  45   // connect to the DSN data source
  46   ret = SQLConnect (dbc,
  47                    (SQLCHAR *) "DSN=mycsql;MODE=csql;SERVER=localhost;", (SQLSMALLINT) strlen ("DSN=mycsql;MODE=csql;SERVER=localhost;"),
  48                    (SQLCHAR *) "root",
  49                    (SQLSMALLINT) strlen ("root"),
  50                    (SQLCHAR *) "manager",
  51                    (SQLSMALLINT) strlen ("manager"));
  52 //SERVER=192.168.1.114;PORT=5678
  53
  54   if(!SQL_SUCCEEDED(ret))
  55   {
  56         printf("Test Failed\n");
  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 2;
  64    }
  65
  66    printf("Test Passed\n");
  67    ret = SQLDisconnect(dbc);
  68    checkrc(ret,__LINE__);
  69    printf("Disconnected from the Datasource\n");
  70
  71    ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
  72    checkrc(ret,__LINE__);
  73
  74    ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
  75    checkrc(ret,__LINE__);
  76    return 0;
  77 }