用ADO连接数据库，为什么打开记录集时用SELECT语句有问题，高手请指教，急

Question

m_pRecordset->Open(_variant_t("SELECT * FROM GTB"),
                  _variant_t((IDispatch *)pMyConnect,true), adOpenKeyset,
adLockOptimistic, adCmdTable);提示错误：在关键字SELECT附近有语法错误高手请指教

Answer 1

try SLECT * FROM [GTB]

Answer 2

m_pRecordset->Open(_variant_t("SELECT * FROM GTB"),
                  _variant_t((IDispatch *)pMyConnect,true), adOpenKeyset,
adLockOptimistic, adCmdTable);
-->
m_pRecordset->Open(_variant_t("GTB"),
                  _variant_t((IDispatch *)pMyConnect,true), adOpenKeyset,
adLockOptimistic, adCmdTable);
或者
m_pRecordset->Open(_variant_t("SELECT * FROM GTB"),
                  _variant_t((IDispatch *)pMyConnect,true), adOpenKeyset,
adLockOptimistic, adModeUnknown);

Answer 3

wistaria(听风听雨)：
      真是高手，非常感谢，有机会还要向你请教