subject_17388.htm

一些关于vc的问答

<p>
序号：17388 发表者：sdf 发表日期：2002-10-11 08:24:23
<br>主题：Provider的设置有问题
<br>内容：我在编写数据库时，执行Open时老是出错，我怀疑是Provider的设置有问题，请教如何设置啊？原代码如下：<BR><BR>&nbsp;&nbsp; m_strConnection=_T("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\My Documents\OilLeakingDetection.mdb");<BR>&nbsp;&nbsp; m_strCmdText=_T("SELECT * FROM SYSREMPARAMETER");<BR>&nbsp;&nbsp;&nbsp;&nbsp;//初始化记录集和绑定指针<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pRs=NULL;<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_piAdoRecordBinding=NULL;<BR>&nbsp;&nbsp;&nbsp;&nbsp;//初始化COM<BR>&nbsp;&nbsp;&nbsp;&nbsp;if(CoInitialize(NULL)!=S_OK)<BR>&nbsp;&nbsp;&nbsp;&nbsp;{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AfxMessageBox("错误：无法初始化COM!");<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return false;<BR>&nbsp;&nbsp;&nbsp;&nbsp;}<BR>&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;&nbsp;//创建记录集对象<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pRs.CreateInstance(_uuidof(Recordset));<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pRs-&gt;Open((LPCTSTR)m_strCmdText,(LPCTSTR)m_strConnection,adOpenDynamic,adLockOptimistic,adCmdUnknown);<BR>&nbsp;&nbsp;&nbsp;&nbsp;//得到一个指向绑定接口的指针<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pRs-&gt;QueryInterface(_uuidof(IADORecordBinding),(LPVOID*)&m_piAdoRecordBinding);<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_piAdoRecordBinding-&gt;BindToRecordset(&m_rsRecSet);
<br><a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p>
<hr size=1>
<blockquote><p>
<font color=red>答案被接受</font><br>回复者：iwill 回复日期：2002-10-11 08:28:40
<br>内容：COM操作一定得判断是否成功,否则很容易异常退出<BR><BR>不要将返回值字直接与S_OK/S_FALSE比较,推荐使用SUCCEEDED宏<BR><BR>主要问题:数据库路径 C:\\My Documents\\OilLeakingDetection.mdb
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：啊志 回复日期：2002-10-11 09:03:22
<br>内容：转移字符。
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>