UC知道C++连接数据库 ADO
来源：百度知道 编辑：UC知道 时间：2024/05/30 00:51:31
_ConnectionPtr m_pConnection; //创建智能指针
m_pConnection.CreateInstance(_uuidof(Connection));
CoInitialize(NULL);
try
{
m_pConnection->ConnectionString="Provider=SQLOLEDB;Persist Security Info=false;Initial Catalog=pubs;Data Source=127.0.0.1;User ID=sa;Password=21259520q";
m_pConnection->Open(" "," "," ",adConnectUnspecified);
}
catch(_com_error e)
{
return ;
}
127.0.0.1那改为(local)也没用，服务器已经打开,pubs是数据库名
m_pConnection.CreateInstance(_uuidof(Connection));
CoInitialize(NULL);
try
{
m_pConnection->ConnectionString="Provider=SQLOLEDB;Persist Security Info=false;Initial Catalog=pubs;Data Source=127.0.0.1;User ID=sa;Password=21259520q";
m_pConnection->Open(" "," "," ",adConnectUnspecified);
}
catch(_com_error e)
{
return ;
}
127.0.0.1那改为(local)也没用，服务器已经打开,pubs是数据库名
Provider=SQLOLEDB.1;Password=XXXXX;Persist Security Info=True;User ID=XXXXX;Initial Catalog=XXXXX;Data Source=.
改成本地应该没有问题，再查一个数据库配置是否正确
我用上面连接本地SQL Server没有问题，你修改一下试试