下面是连接数据库时候的代码 ::CoInitialize(NULL);
strname.Format("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=%s;Data Source=.",strsjk);
//strsjk为传进来的数据库名
try
{
m_pConnection.CreateInstance("ADODB.Connection");//m_pConnection为_ConnectionPtr型
_bstr_t strConnect=strname;
m_pConnection->Open(strConnect,"","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}
}
调试到红色代码时候,跟不下去了,提示很多如Loaded 'C:\WINDOWS\system32\dbnmpntw.dll', no matching symbolic information found.之类的信息。
这是怎么回事呢???我改了下
strname.Format("Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=%s");
try
{
m_pConnection.CreateInstance("ADODB.Connection");
m_pConnection->ConnectionString = _bstr_t(strname);
m_pConnection->Open("","","",adModeUnknown);
.................................
改成上面也是同样的问题 ,不知道怎么了 谢谢
strname.Format("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=%s;Data Source=.",strsjk);
//strsjk为传进来的数据库名
try
{
m_pConnection.CreateInstance("ADODB.Connection");//m_pConnection为_ConnectionPtr型
_bstr_t strConnect=strname;
m_pConnection->Open(strConnect,"","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}
}
调试到红色代码时候,跟不下去了,提示很多如Loaded 'C:\WINDOWS\system32\dbnmpntw.dll', no matching symbolic information found.之类的信息。
这是怎么回事呢???我改了下
strname.Format("Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=%s");
try
{
m_pConnection.CreateInstance("ADODB.Connection");
m_pConnection->ConnectionString = _bstr_t(strname);
m_pConnection->Open("","","",adModeUnknown);
.................................
改成上面也是同样的问题 ,不知道怎么了 谢谢
strname.Format("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=%s;Data Source=192.168.0.12",strsjk);
后来我改成混合认证了 但是 都没行通???
恩 兄弟 可以去我另外2帖子留个话,我好把那2帖子结了,不然分浪费了可惜
晕了 今天太蹊跷了
还是提示Loaded 'C:\WINDOWS\system32\winrnr.dll', no matching symbolic information found.之类的提示
要是不调试的话就弹出个对话框,说是:用户'(NULL)'登陆失败。原因:未与信任SQL Server连接相关联
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=;Initial Catalog=%s;Data Source=IP
ok 搞定
可以了 不过不是很清楚为什么window认证登陆不行呢???有点迷糊。
恩 非常感谢你哦