C / C++ / MFC

void PrintProviderError(_ConnectionPtr pConnection)

{

//Define Other Variables

HRESULT hr = S_OK;

_bstr_t strError;

ErrorPtr pErr = NULL;


try

{

// Enumerate Errors collection and display

// properties of each Error object.

long nCount = pConnection->Errors->Count;


// Collection ranges from 0 to nCount - 1.

for(long i = 0; i < nCount; i++)

{

pErr = pConnection->Errors->GetItem(i);

CString temp;

temp.Format("Error #%d\n", pErr->Number);

AfxMessageBox(temp);

temp.Format(" %s\n",(LPCSTR)pErr->Description);

AfxMessageBox(temp);

temp.Format(" (Source: %s)\n",(LPCSTR)pErr->Source);

AfxMessageBox(temp);

temp.Format(" (SQL State: %s)\n",(LPCSTR)pErr->SQLState);

AfxMessageBox(temp);

temp.Format(" (NativeError: %d)\n",(LPCSTR)pErr->NativeError);

AfxMessageBox(temp);



if ((LPCSTR)pErr->GetHelpFile() == NULL)

{

AfxMessageBox("\tNo Help file available\n");

}

else

{
CString temp1;
temp1.Format("\t(HelpFile: %s\n)" ,pErr->HelpFile);

AfxMessageBox(temp1);

temp1.Format("\t(HelpContext: %s\n)" , pErr->HelpContext);

AfxMessageBox(temp1);

}

}

}

catch(_com_error &e)

{

// Notify the user of errors if any.

PrintComError(e);

}

}


///////////////////////////////////////////////////////////

// //

// PrintComError Function //

// //

///////////////////////////////////////////////////////////


void PrintComError(_com_error &e)

{

// Notify the user of errors if any.

_bstr_t bstrSource(e.Source());

_bstr_t bstrDescription(e.Description());


// Print Com errors.


AfxMessageBox("Error\n");

CString temp;

temp.Format("\tCode = %08lx\n", e.Error());

AfxMessageBox(temp);

temp.Format("\tCode meaning = %s", e.ErrorMessage());

AfxMessageBox(temp);

temp.Format("\tSource = %s\n", (LPCSTR) bstrSource);

AfxMessageBox(temp);

temp.Format("\tDescription = %s\n", (LPCSTR) bstrDescription);

AfxMessageBox(temp);

}