CDatabase m_db;virtual BOOL OpenEx(LPCTSTR lpszConnectString,DWORD dwOptions =0);
throw(CDBException,CMmoryException);
CString strConnect;
strConnect.Format("DSN=%s;UID=%s;PWD=%s","MyServer","snipzy","snipzy");
TRY{
m_db.OpenEx(strconnect,CDatabase::noOdbcDialog);
}
CATCH(CDBException,ex)
{AfxMessageBox(ex->m_strError);
AfxMessageBox(ex->m_strStateNativeOrigin);
}
AND_CATCH(CMemoryException,pEx)
{pEx->ReportError();
AfxMessageBox("memory exception");
}
AND_CATCH(CException,e)
{
  TCHAR szError[100];
e->GetErrorMessage(szError,100);
AfxMessageBox(szError);
}
END_CATCH