int Connection(idbSes *Ss, char *SName, char *uid, char *psw)
{
	SQLHENV *hEnv = &Ss->hEnv;
	SQLHDBC *hDBC = &Ss->hDBC;
	RETCODE rc;

	// Allocates environment 
	rc = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, hEnv);
	if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO) return IDB_CON_FAIL;
	
	// Sets environmental attributes
	rc = SQLSetEnvAttr(*hEnv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3,  0 );
	if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO) 
        {
                   SQLFreeHandle(SQL_HANDLE_ENV, *hEnv);
                   return IDB_CON_FAIL;
        }
	
	// Allocates space for connection
	rc = SQLAllocHandle(SQL_HANDLE_DBC, *hEnv, hDBC);
	if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO)
        {
	         SQLFreeHandle(SQL_HANDLE_ENV, *hEnv);	
	         return IDB_CON_FAIL;
        }

	// Set login timeout as 5 seconds
	SQLSetConnectAttr(hDBC, SQL_ATTR_CONNECTION_TIMEOUT, (void *) 5 ,  0 );
	SQLSetConnectAttr(hDBC, SQL_ATTR_LOGIN_TIMEOUT, (void *) 5 ,  0 );
	
	// Connection
	rc = SQLConnect( *hDBC, (SQLCHAR *)SName, strlen (SName), (SQLCHAR *)uid, strlen (uid), (SQLCHAR *)psw, strlen (psw));

	if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO)
	{
		SQLFreeHandle(SQL_HANDLE_DBC, *hDBC);
		SQLFreeHandle(SQL_HANDLE_ENV, *hEnv);	
		return IDB_CON_FAIL;
	}

	return IDB_OK;
}

int Disconnection (idbSes *Ss)
{
	SQLHENV *hEnv = &Ss->hEnv;
	SQLHDBC *hDBC = &Ss->hDBC;
	RETCODE rc;

	rc = SQLDisconnect(*hDBC);
	if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO) return IDB_DISCON_FAIL;

	rc = SQLFreeHandle(SQL_HANDLE_DBC, *hDBC);
	if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO) return IDB_DISCON_FAIL;

	rc = SQLFreeHandle(SQL_HANDLE_ENV, *hEnv);
	if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO) return IDB_DISCON_FAIL;

	return IDB_OK;	
}