C / C++ / MFC

// print out local host IP address
char name[256] = "";
int nRet = gethostname(name, sizeof(name));
if ( nRet == SOCKET_ERROR )
    MessageBox("gethostname() failed");
else
{
    struct hostent * host = gethostbyname(name);
    if ( host == NULL )
        MessageBox("gethostbyname() failed");
    else
    {
        struct in_addr addr;
        memcpy(&addr, host->h_addr_list[0], sizeof(addr));
        CString m_strHost;
        m_strHost.Format( "%s", inet_ntoa(addr));
        // do whatever you want to do with the obtained IP address
    }
}

_variant_t vt = pRecordset->Fields->GetItem("Test")->Value;

if (vt.vt == VT_NULL)
{
  AfxMessageBox("Field is NULL");
}
else
{
strTemp.Format("Test Column:%s",(LPSTR)(_bstr_t)vt); 
AfxMessageBox(strTemp);
}

<br />
(LPSTR)(_bstr_t)pRecordset->Fields->GetItem("Test")->Value); <br />

<br />
IFieldPtr field;<br />
try<br />
{<br />
  field = pRecordset->Fields->GetItem("Test");<br />
} <br />
catch(com_error e) <br />
{ <br />
  field = NULL;<br />
}<br />
<br />
if(field != NULL)<br />
{<br />
  _variant_t vtVal;<br />
  try<br />
  {<br />
    vtVal = field->Value;<br />
  } catch (_com_error e) {vtVal.vt = VT_ERROR; }<br />
  <br />
  _bstr_t bstrVal;<br />
  if(vtVal.vt != VT_ERROR)<br />
  {<br />
     try{ bstrVal = (_bstr_t)vtVal; }<br />
     catch(com_error e) {bstrVal = L"";}<br />
  }<br />
  <br />
  AfxMessageBox((LPCTSTR)bstrVal);<br />
}<br />
<br />