我的后台数据库是用WINDOWS身份验证连接使用的,在初始化—连接数据库的时候,添加连接变量的时候该如何设置uid和pwd,当我用登陆windows时的用户名和密码的时候,却发现连接数据库失败?不知该怎么办?请大家指教一二?
CString strConn;
::CoInitialize(NULL);
try
{// 创建Connection对象
::SetCursor(::LoadCursor(NULL, IDC_WAIT));
m_pConnection.CreateInstance("ADODB.Connection");
strConn.Format("Provider=SQLOLEDB;Server=A96137752A00443;Database=tongue;uid=xuchao;pwd=tonguetest;",strServiecName,strDBName); // 设置连接字符串,必须是BSTR型或者_bstr_t类型
m_pConnection->Open(_bstr_t(strConn),"","",adModeUnknown);
return true;
CString strConn;
::CoInitialize(NULL);
try
{// 创建Connection对象
::SetCursor(::LoadCursor(NULL, IDC_WAIT));
m_pConnection.CreateInstance("ADODB.Connection");
strConn.Format("Provider=SQLOLEDB;Server=A96137752A00443;Database=tongue;uid=xuchao;pwd=tonguetest;",strServiecName,strDBName); // 设置连接字符串,必须是BSTR型或者_bstr_t类型
m_pConnection->Open(_bstr_t(strConn),"","",adModeUnknown);
return true;
//初始化数据库连接环境
//
::CoInitialize(NULL); MyConnection.CreateInstance("ADODB.Connection"); //
// 设置连接字符串,必须是BSTR型或者_bstr_t类型
//
_bstr_t MyConnectionStr = "Provider=SQLOLEDB; Server=172.16.4.13;Database=CPPN; uid=sa; pwd=;";
try
{
MyConnection->Open(MyConnectionStr, "", "", 0);
} //
// 捕捉异常
//
catch(_com_error e)
{
// 显示错误信息
AfxMessageBox(e.Description());
}
BSTR SQL = strConn.AllocSysString();试试看