怎么感觉你的连接语句像是C#啊?
改成这样子试一试?
_bstr_t strConnect = "Provider=SQLOLEDB;Data Source=.;Initial Catalog=HR;User ID=sa;
password=123";
改成这样子试一试?
_bstr_t strConnect = "Provider=SQLOLEDB;Data Source=.;Initial Catalog=HR;User ID=sa;
password=123";
解决方案 »
- 关于删除内存DC的图形数据信息的问题??
- 请帮我看一下我的代码?程序运行时为什么会死掉,先谢谢了!!
- VC下如何改变picture控件的背景色
- 谁有directX9.0的结构,函数,宏的中文手册或相关中文资料
- 如果利用SDK编程实现Button上面显示tooltip.
- RealOne播放文件时,抓屏时图像无法抓取到?RealOne是怎么个播放机制,要怎么才能抓取到?
- 请问这是怎么回事?
- 怪异的数,int a = (int)(2.3 *100)到底返回多少,请试一试!!
- 关于C语言的学法
- 怎么可以使长整型的数据首位可以显示0。例如:0876234,请赐教?
- VC++用MFC编的大程序一般怎么看?(没文档和注释)
- 为什么COM的书都绝版了呢?
CoInitialize(NULL);
_ConnectionPtr pConn(_uuidof(Connection));
_RecordsetPtr pRst(_uuidof(Recordset));
_CommandPtr pComm(_uuidof(Command));pConn->ConnectionString="Provider=SQLOLEDB.1;User ID=admin;Password=admin;Persist Security Info=True;Initial Catalog=MyDB;Data Source=.";
pConn->Open("","","",-1);
pComm->put_ActiveConnection(_variant_t((IDispatch*)pConn));
CString cmdText = "select * from 表名";
pConn->Close();
pConn.Release();
CoUninitialize();
pComm->CommandText =(_bstr_t) cmdText;
pRst = pComm->Execute(NULL,NULL,adCmdText);
CoInitialize(NULL);
_ConnectionPtr pConn(_uuidof(Connection));
_RecordsetPtr pRst(_uuidof(Recordset));
_CommandPtr pComm(_uuidof(Command));pConn->ConnectionString="Provider=SQLOLEDB.1;User ID=admin;Password=admin;Persist Security Info=True;Initial Catalog=MyDB;Data Source=.";
pConn->Open("","","",-1);
pComm->put_ActiveConnection(_variant_t((IDispatch*)pConn));
CString cmdText = "select * from 表名";
pComm->CommandText =(_bstr_t) cmdText;
pRst = pComm->Execute(NULL,NULL,adCmdText);
pConn->Close();
pConn.Release();
CoUninitialize();
写错顺序了,不好意思
m_pCon->Open(strConnect,"","",adModeUnknown);机器名是你的windows-〉系统面版里的名字哦
m_pConnection-> Open(strConnect, " ", " ",adModeUnknown); //如果还连不上的话,确定SQLServer的身份认证是混合方式认证,而不是windows认证。