subject_28273.htm

vc

<p>
序号：28273 发表者：二进制 发表日期：2003-01-20 10:06:47
<br>主题：用ODBC访问ACCESS库，求救！
<br>内容：&nbsp;&nbsp;&nbsp;&nbsp;CString&nbsp;&nbsp;sDSN="ODBC;DRIVER=Microsoft Access Driver (*.mdb);DSN='';DBQ=colist.mdb";<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_tmpdb =new CDatabase;<BR>&nbsp;&nbsp;&nbsp;&nbsp;if(!m_tmpdb-&gt;Open(NULL,FALSE,FALSE,sDSN,FALSE))<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pSet=new JhdbRecordset(m_tmpdb);<BR>&nbsp;&nbsp;&nbsp;&nbsp;strSQL="select * from companylist";&nbsp;&nbsp;&nbsp;&nbsp; //（1）<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pSet-&gt;Open(CRecordset::dynaset,strSQL);<BR>以上代码没问题。但如果把（1）行改为：<BR>　　　　　strSQL="select * from companylist　where [username]=adm";<BR>则在执行时[username]不能接收到参数"adm"，提示参数不足，期待是1。如在ACCESS中执行则没问题。<BR>　　　　　Help me!<BR>2003-1-20 10:55:53