how to update records of remote server database mysql

Question

How to update the remote server data in vc++ 6.0 , i am able to retrieve the data but not updating.

here i am tryng but dont know how to update

pleae help.

CRecordset cRecord(&db);
cString csQuery;
csQuery.Format(L"select * from %s where product_name = %s", m_TableName,
    m_ProductName);
TRY
{
    cRecord.Open(CRecordset::snapshot, csQuery, CRecordset::none);
    if(cRecord.IsOpen())
    {
        while(!cRecord.IsEOF())
        {
            cRecord.Edit();        
            // how to update

            cRecord.Update();

            cRecord.MoveNext(); 

        } // while(!cRecord.IsEOF())
        cRecord.Close();
        db.Close();