ADO的连接？？？？？？？？？？？？？？？？

[zhaodegui]

HRESULT hr;
_bstr_t strconn;
_ConnectionPtr pCn=NULL;
hr=::CoInitialize(NULL);
AssertValid();
if (FAILED(hr))
{
AfxMessageBox("Fail Initial Com!");
}
else
{
AfxMessageBox("Successfully Initial Com!");
}

hr=pCn.CreateInstance(_uuidof(Connection));
if (FAILED(hr))
{
AfxMessageBox("Fail Connection!");
}
else
{
AfxMessageBox("Successfully Connection!");
}

strconn="Provider=SQLOLEDB; Server=DONGXING2\SERVER;Database=rd; uid=sa; pwd=''";
try
{
pCn->Open((_bstr_t)strconn,"","",NULL);
}
catch(_com_error &e)
{
AfxMessageBox(e.ErrorMessage());
}


出现了不支持此接口的错误，请各位高手指点一上！！！

[DebugXP]

strconn="Provider=SQLOLEDB.1;Password=;Persist Security Info=True;User ID=sa;Initial Catalog=rd;Data Source=DONGXING2\SERVER";

try
{
pCn->Open((_bstr_t)strconn,"","",adModeUnknown);
}
catch(_com_error &e)
{
AfxMessageBox(e.ErrorMessage());
}

[醉马不肖]

那出错

[zhaodegui]

打开数据库的时候，给出错误信息"不支持此接口！"

[eYah]

Provider=SQLOLEDB.1;Data Source=xxx;Initial Catalog=xxx;User ID=xxx; PWD=xxx;
这里数据库指定是 initial catalog, datasource是数据服务器名或IP
另外检查mdac版本
sql2000 ---> mdac 2.6
sql7.0 ---> mdac 2.5