VC连接数据库的问题（ADO）在线等待 立结+诚恳

[jyg8888]

我写了个利用ADO连接数据库操作的测试程序 很短
=============
#include<iostream.h>
#include<afxwin.h>
#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")
void main()
{
_ConnectionPtr m_Con;
::CoInitialize(NULL);//初始化COM
m_Con=NULL;
HRESULT hr;
hr=m_Con.CreateInstance("ADODB.Connection");//

if(SUCCEEDED(hr))
{::MessageBox(NULL,"OK","gg",0); }

hr=m_Con->Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\Factory\\VC\\test.mdb","","",adConnectUnspecified);
if(SUCCEEDED(hr))
{::MessageBox(NULL,"OK","gg",0); }
VARIANT VAL;
m_Con->Execute("insert into MAIN (NAME,WAGE) values ('USER1',1111)",&VAL,1);
m_Con->Execute("insert into MAIN (NAME,WAGE) values ('USER2',2222)",&VAL,1);
m_Con->Execute("insert into MAIN (NAME,WAGE) values ('USER3',3333)",&VAL,1);


m_Con->Close();
m_Con=NULL;
CoUninitialize();




}
====================================
但出现一个我难以解释的情况
为什么执行到
m_Con->Execute("insert into MAIN (NAME,WAGE) values ('USER2',2222)",&VAL,1);
就会出现程序异常的错误框而结束呢
我发现
m_Con->Execute("insert into MAIN (NAME,WAGE) values ('USER1',1111)",&VAL,1);
确实是被加到数据库了
请各位前辈帮我看看呐
诚恳跪谢

[Jimmy_Xia]

加入出错捕获
try
{
m_Con->Execute("insert into MAIN (NAME,WAGE) values ('USER1',1111)",&VAL,1);
m_Con->Execute("insert into MAIN (NAME,WAGE) values ('USER2',2222)",&VAL,1);
m_Con->Execute("insert into MAIN (NAME,WAGE) values ('USER3',3333)",&VAL,1);
}
catch(const _com_error e)
{
AfxMessageBox(e.Description());
long errCode=e.WCode();
if(3127==errCode) AfxMessageBox("表不存在");
else if(3092==errCode) AfxMessageBox("表已经存在");
return FALSE;
}
分析原因
good luck

[cpio]

用这个试试：

_variant_t val;

[T97102003]

NAME是ACCESS保留字,要用[]括起来

[joinclear]

m_Con->Execute("insert into MAIN (NAME,WAGE) values ('USER2',2222)",&RecordsAffected,adCmdText);

这样试试

[快乐鹦鹉]

VARIANT VAL;
m_Con->Execute("insert into MAIN (NAME,WAGE) values ('USER1',1111)",&VAL,1);
VARIANT VAL2;
m_Con->Execute("insert into MAIN (NAME,WAGE) values ('USER2',2222)",&VAL2,1);
试试

[jyg8888]

不行啊 两位我都实验过了 一样结果
晕 之前小弟有VB上使用ADO的经验
这次虽然在VC上用 很多东西都感觉到眼熟
但也有很多不同点
现在边看VB方面ADO参考看来不行
前辈能否告知小弟 在那边能找到VC上使用ADO的参考吗
MSDN该以什么为关键字啊
如果那为有范例的话最好能给份 大恩大德 铭记在心
我的MAIL [e-mail]
再次感谢