// Select a table
  varSQL.bstrVal = TEXT("SELECT * FROM Video");
  varSQL.vt = VT_BSTR;
 
  hr = m_iADOCERS->Open(varSQL, m_varConn, adOpenDynamic, adLockOptimistic, adCmdUnknown);
  PrintHRESULT(hr);
  ASSERT(SUCCEEDED(hr));