一般SQL验证登录为如下语句:
::CoInitialize(NULL);
try
{
// 创建Connection对象
m_pConnection.CreateInstance("ADODB.Connection");
// 设置连接字符串,必须是BSTR型或者_bstr_t类型
_bstr_t strConnect = "Provider=SQLOLEDB; Server=ntserver;Database=PIRATE; uid=sa; pwd=sa;";
m_pConnection->Open(strConnect,"","",adModeUnknown);
}
// 捕捉异常
catch(_com_error e)
{
// 显示错误信息
AfxMessageBox(e.Description());
} 但是我用的是Windows的系统默认登录,并不需要用户名和密码。那么这条连接语句该如何改?
_bstr_t strConnect = "Provider=SQLOLEDB; Server=ntserver;Database=PIRATE; uid=sa; pwd=sa;";
::CoInitialize(NULL);
try
{
// 创建Connection对象
m_pConnection.CreateInstance("ADODB.Connection");
// 设置连接字符串,必须是BSTR型或者_bstr_t类型
_bstr_t strConnect = "Provider=SQLOLEDB; Server=ntserver;Database=PIRATE; uid=sa; pwd=sa;";
m_pConnection->Open(strConnect,"","",adModeUnknown);
}
// 捕捉异常
catch(_com_error e)
{
// 显示错误信息
AfxMessageBox(e.Description());
} 但是我用的是Windows的系统默认登录,并不需要用户名和密码。那么这条连接语句该如何改?
_bstr_t strConnect = "Provider=SQLOLEDB; Server=ntserver;Database=PIRATE; uid=sa; pwd=sa;";
Initial Catalog=PIRATE;Data Source=(local)"