MFC用ODBC连接db2数据库

现技术较劣，用博客记下一段段，日后厚积薄发。

	CDatabase m_dbCust;

	BOOL iResult = m_dbCust.Open(_T("COOLXIAO"),FALSE,FALSE,_T("ODBC;UID = db2;PWD = dd2003"),FALSE);
	if(!iResult)
	{
		MessageBox(_T("Error"));
	}
	
	CRecordset m_dbSet(&m_dbCust);
	CString szSQL;
	szSQL.Format(_T("%s"),_T("select * from t_employee"));
	iResult = m_dbSet.Open(CRecordset::forwardOnly,szSQL);
	short nFileds = m_dbSet.GetODBCFieldCount();

	if(iResult)
	{
		CDBVariant ps;
		while(!m_dbSet.IsEOF())
		{
			
			CString szID;
			m_dbSet.GetFieldValue(2,ps);
			if(ps.m_dwType == DBVT_LONG)
				szID.Format(_T("%u"),ps.m_lVal);
			m_dbSet.MoveNext();

		}
		
	}

	m_dbCust.ExecuteSQL(_T("update t_employee set fage = 50 "));