VC++使用ADO技术连接SQL2000解决方案

VC++使用ADO技术连接SQL2000
连接没设密码的sql2000数据库可以连接，数据库用户名为sa,密码为空，代码如下：
void ADOConn::OnInitADOConn()//构造ADO对象时自动调用打开连接
{
::CoInitialize(NULL);//初始化COM库环境
try
{
  m_pConnection.CreateInstance("ADODB.Connection");//创建connection对象
//设置连接字符串
_bstr_t strConnect="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=GZFFXT;Data Source=.";
//根据SERVER和UID,PWD的设置根据实际情况来设置
m_pConnection->Open(strConnect,"","",adModeUnknown);
}
catch(_com_error e)//捕捉异常
{
AfxMessageBox(e.Description());//显示错误信息
}
}
但是现在我想连接设有密码的sql2000数据库，数据库用户名为sa，密码为123，那么该怎么修改代码，求指教

[解决办法]
strSQL.Format(_T("Provider=SQLOLEDB;Server=%s;Database=%s;uid=%s;pwd=%s;"),strServer,strDatabase,strServerUser,strServerPassword);
m_pConnection->Open(strSQL,"","",adModeUnknown);
[解决办法]
Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
按上面这个修改试试。
[解决办法]

探讨

strSQL.Format(_T("Provider=SQLOLEDB;Server=%s;Database=%s;uid=%s;pwd=%s;"),strServer,strDatabase,strServerUser,strServerPassword);
m_pConnection->Open(strSQL,"","",adModeUnknown);

[解决办法]
_bstr_t strConnect="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;user=sa;pwd=123;Initial Catalog=GZFFXT;Data Source=.";

[解决办法]
我都是这么写的：
strSql.Format(TEXT("Driver=SQL Server;Server=%s;Database=%s;UID=%s;PWD=%s"),
m_strDbAddress,m_strDbName,m_strAccount,m_strPassword);
[解决办法]
CString m_sConn = "";
m_sConn.Format("Provider=SQLOLEDB.1;Persist Security Info=True;User ID=%s;Password=%s;\
Initial Catalog=%s;Data Source=%s,%d;Network Library=DBMSSOCN",
m_infoSrv.m_sUser.c_str(),m_infoSrv.m_sCode.c_str(),m_infoSrv.m_sDataSrc.c_str(),
m_infoSrv.m_sAddr.c_str(),m_infoSrv.m_nPort);


hr = m_pConnection->Open((_bstr_t)m_sConn,"","",adConnectUnspecified);
[解决办法]
这样使用：
m_ConnectionString=_T("Provider=SQLOLEDB;Server=(local);Database=GZFFXT; uid=sa;Password=123;");

查看更多 下一篇