我写了个利用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);
确实是被加到数据库了
请各位前辈帮我看看呐
诚恳跪谢
=============
#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);
确实是被加到数据库了
请各位前辈帮我看看呐
诚恳跪谢
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);
试试
晕 之前小弟有VB上使用ADO的经验
这次虽然在VC上用 很多东西都感觉到眼熟
但也有很多不同点
现在边看VB方面ADO参考看来不行
前辈能否告知小弟 在那边能找到VC上使用ADO的参考吗
MSDN该以什么为关键字啊
如果那为有范例的话最好能给份 大恩大德 铭记在心
我的MAIL [email protected]
再次感谢
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