VC连接SQL SERVER时总是联不上，抛出异常！！！

Question

::CoInitialize(NULL);
AfxOleInit();
try
{
m_pConnection.CreateInstance("ADODB.Connection");_bstr_t strConnect="Provider=SQLOLEDB.1;password=sa; Persist Security=True;User ID=sa; Initial Catalog=shebei;Data Source=lzq;";m_pConnection->Open(strConnect,"","",adModeUnknown);
if(m_pConnection->State==adStateOpen)
MessageBox("sucessful");
m_pConnection->Close();
if(m_pConnection->State==adStateClosed)
MessageBox("Cut off");
}
catch(_com_error e)
{AfxMessageBox(e.ErrorMessage());
}
::CoUninitialize();
这段代码是在对话框初始化函数里加的，但无论如何都执行AfxMessageBox(e.ErrorMessage();
有异常，是怎么回事呢？我机器名叫lzq,数据库名叫shebei.
我单步调试发现是m_pConnection->Open(strConnect,"","",adModeUnknown);这句异常。
请大家教教我！！！

Answer 1

你的不清楚怎么回事,我的这样可以,你看一下吧:
bstr="Provider=SQLOLEDB.1;Persist Security Info=FALSE;server=dbname;user id=sa";
_bstr_t sCnn(bstr);

hr = m_pConn.CreateInstance(__uuidof(Connection));

if(!SUCCEEDED(hr))
return 1;//发生错误！

try
{
hr=m_pConn->Open(sCnn,"","",adModeUnknown);
if(SUCCEEDED(hr))
{
m_iSuccessFlag=1;
}
}

Answer 2

去掉Persist Security=True;或者改为false
还不行该为ip地址看看