这是我的代码,我发现两种方式都连不上,老是运行的时候报错,当然编译还是可以通过的,我建立了一个数据库school,里面存放了三张表Student,Course,Sc,想把一些属性输出到控件上,可惜老是连不上,下面是代码!
void CLessons_ADODlg::OnBtnQuery()
{ CoInitialize(NULL);//初始化类库
_ConnectionPtr pConn(__uuidof(Connection));//定义并初始化。 Data Source=MICROSOF-C59AA9;
_RecordsetPtr pRst(__uuidof(Recordset)); //pConn->ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs";
pConn->ConnectionString="Provider=SQLOLEDB;Data Source=localhost\SqlExpress;InitialCatalog=school;User ID=sa;Password=123456";
pConn->Open("ConnectionString","sa","123456",NULL);
//小心啊,注意查看Open(ADO) pRst=pConn->Execute("select * from Student ",NULL,adCmdText); while(pRst->rsEOF)
{
((CListBox*)GetDlgItem(IDC_LIST1))->AddString((_bstr_t)pRst->
GetCollect("sno"));
pRst->MoveNext();
}
pRst->Close();
pConn->Close();
//pCmd.Release();
pRst.Release();
pConn.Release(); CoUninitialize();
}
后来我又改了一下,还是不行。
HRESULT hr;
_ConnectionPtr m_pConnection;
hr = m_pConnection.CreateInstance("ADODB.Connection");
hr = m_pConnection->Open("Provider=SQLOLEDB;Data Source=localhost\SqlExpress","sa","123456",adModeUnknown);
_RecordsetPtr pRst(__uuidof(Recordset));
pRst=m_pConnection->Execute("select * from Student ",NULL,adCmdText);
while(pRst->rsEOF)
{
((CListBox*)GetDlgItem(IDC_LIST1))->AddString((_bstr_t)pRst->
GetCollect("sno"));
pRst->MoveNext();
}
pRst->Close();
m_pConnection->Close();
pRst.Release();
m_pConnection.Release();高手求救啊!
void CLessons_ADODlg::OnBtnQuery()
{ CoInitialize(NULL);//初始化类库
_ConnectionPtr pConn(__uuidof(Connection));//定义并初始化。 Data Source=MICROSOF-C59AA9;
_RecordsetPtr pRst(__uuidof(Recordset)); //pConn->ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs";
pConn->ConnectionString="Provider=SQLOLEDB;Data Source=localhost\SqlExpress;InitialCatalog=school;User ID=sa;Password=123456";
pConn->Open("ConnectionString","sa","123456",NULL);
//小心啊,注意查看Open(ADO) pRst=pConn->Execute("select * from Student ",NULL,adCmdText); while(pRst->rsEOF)
{
((CListBox*)GetDlgItem(IDC_LIST1))->AddString((_bstr_t)pRst->
GetCollect("sno"));
pRst->MoveNext();
}
pRst->Close();
pConn->Close();
//pCmd.Release();
pRst.Release();
pConn.Release(); CoUninitialize();
}
后来我又改了一下,还是不行。
HRESULT hr;
_ConnectionPtr m_pConnection;
hr = m_pConnection.CreateInstance("ADODB.Connection");
hr = m_pConnection->Open("Provider=SQLOLEDB;Data Source=localhost\SqlExpress","sa","123456",adModeUnknown);
_RecordsetPtr pRst(__uuidof(Recordset));
pRst=m_pConnection->Execute("select * from Student ",NULL,adCmdText);
while(pRst->rsEOF)
{
((CListBox*)GetDlgItem(IDC_LIST1))->AddString((_bstr_t)pRst->
GetCollect("sno"));
pRst->MoveNext();
}
pRst->Close();
m_pConnection->Close();
pRst.Release();
m_pConnection.Release();高手求救啊!
解决方案 »
- VC折线图
- 关于绘制彩色按钮
- 如何高效干净地弹出盘符
- 编译出现错误,各位来给帮忙了
- 请问各位大虾,在VC中对于一个编译成功且已经生成exe文件,在源代码中如何调出它的各个控件重新进行编辑一下控件上的文字!
- 如何向另一个程序中按钮发送单击消息
- 为什么程序必须以win98兼容模式才能运行?
- 请问答了这个问题(源贴编号http://expert.csdn.net/Expert/topic/1481/1481122.xml?temp=.4470178)的人近来接分,不管您是否回答好了?
- 有没有试过用Windows作为客户端,而linux作为服务器的socket开发。
- dcom中如何实现文件传输?
- 用VC做一个网络监测器
- 关于CListCtrl控件使用时发生内存冲突的问题
pConn->Open("ConnectionString","sa","123456",NULL);这句就可以改成
pConn->Open("","","",adConnectUnspecified);
ConnectionString属性中要是要连接本机上的SQL的话就可以把ConnectionString里面的
Data Source设为:(local)
Data Source=(local);
我想就能连接上了。