CoInitialize(NULL); _ConnectionPtr m_connection;
_RecordsetPtr m_recordset;
_CommandPtr m_command; HRESULT hr;
_bstr_t source("Driver={SQL Server};Server=20090615-1415;\
Uid=sa;Pwd=yu2808487;Database=master"); _bstr_t user("");
_bstr_t pwd("");
try{
hr = m_connection.CreateInstance(_uuidof(Connection));
if(SUCCEEDED(hr))
hr = m_connection->Open(source,"","",16);
if(SUCCEEDED(hr))
hr = m_recordset.CreateInstance(_uuidof(Recordset));
if(SUCCEEDED(hr))
m_fConnected = TRUE;
else
m_fConnected = FALSE;
}
catch (_com_error &e){
MessageBox(e.ErrorMessage());
m_fConnected = FALSE;
}
if(!m_fConnected)
MessageBox("ADO数据源初始化失败!");
else
{
if(m_connection->State)MessageBox("connect really open");
_variant_t rec;
COleVariant vtOptional((long)DISP_E_PARAMNOTFOUND,VT_ERROR);m_connection->Execute(_bstr_t(strSQL),&vtOptional,-1); //调试运行到这一步就无法进行下一步 为什么m_connection.Release();
AfxMessageBox("ok!");
}
_RecordsetPtr m_recordset;
_CommandPtr m_command; HRESULT hr;
_bstr_t source("Driver={SQL Server};Server=20090615-1415;\
Uid=sa;Pwd=yu2808487;Database=master"); _bstr_t user("");
_bstr_t pwd("");
try{
hr = m_connection.CreateInstance(_uuidof(Connection));
if(SUCCEEDED(hr))
hr = m_connection->Open(source,"","",16);
if(SUCCEEDED(hr))
hr = m_recordset.CreateInstance(_uuidof(Recordset));
if(SUCCEEDED(hr))
m_fConnected = TRUE;
else
m_fConnected = FALSE;
}
catch (_com_error &e){
MessageBox(e.ErrorMessage());
m_fConnected = FALSE;
}
if(!m_fConnected)
MessageBox("ADO数据源初始化失败!");
else
{
if(m_connection->State)MessageBox("connect really open");
_variant_t rec;
COleVariant vtOptional((long)DISP_E_PARAMNOTFOUND,VT_ERROR);m_connection->Execute(_bstr_t(strSQL),&vtOptional,-1); //调试运行到这一步就无法进行下一步 为什么m_connection.Release();
AfxMessageBox("ok!");
}
解决方案 »
- copydata发送的数据是乱码,请明白人进来看看
- VC开发Office控件,用什么技术?
- 如何使listcontrol每行前面有check box
- 谁能解释一下奇怪的MFC问题.
- cannot open file "..\..\..\..\lib\aa.lib
- 使用CInternetSession创建实例时为什么异常终止?
- 单文档程序,需要打开不同的doc,这时,内存在哪里释放啊
- 如何把动态鼠标.ani文件作为执行程序文件里的资源(就象将位图插入.rc资源文件)?而不是调用.ani文件.
- 如何使用CHttpFile,在Read前就获得文件的长度。
- 如何显示菜单?
- 新手求教SQL 2000数据库连接问题!!!
- 关于Toolbar,只有seperator
你的SQL语句看看有没有问题
你在查询分析器里面运行一下看看
有没有错
_RecordsetPtr m_recordset;
_CommandPtr m_command;HRESULT hr;
_bstr_t source("Driver={SQL Server};Server=20090615-1415;\
Uid=sa;Pwd=yu2808487;Database=master");_bstr_t user("");
_bstr_t pwd("");
try{
hr = m_connection.CreateInstance(_uuidof(Connection));
if(SUCCEEDED(hr))
hr = m_connection->Open(source,"","",16);if(!SUCCEEDED(hr))
MessageBox("ADO数据源初始化失败!");
else
{
MessageBox("connect really open");
long vtOptional = 0;
m_connection->Execute(_bstr_t(strSQL),&vtOptional,adCmdText); //调试运行到这一步就无法进行下一步 为什么m_connection.Release();
AfxMessageBox("ok!");
}
catch (_com_error &e){
MessageBox(e.ErrorMessage());
m_fConnected = FALSE;
}
}
这样试试看
在查询分析器运行你的sql语句,看看能否执行成功先...