ado连接sql server 2000提示“连接数据库失败，未指定的错误 ”

Question

ado连接sql server 2000，提示“连接数据库失败，未指定的错误 ”
下面是我的代码BOOL CDemoApp::InitInstance()
{
AfxOleInit();///初始化COM库
////////////连接数据库//////////////
HRESULT hr;
try
{
hr = m_pConnection.CreateInstance("ADODB.Connection");///创建Connection对象
if(SUCCEEDED(hr))
hr = m_pConnection->Open("Provider=SQLOLEDB;data source=Yl001;initial catalog=Yl001;userid=sa;password=;","","",adModeUnknown);///连接数据库
          }
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
errormessage.Format("连接数据库失败!\r\n错误信息:%s",e.ErrorMessage());
AfxMessageBox(errormessage);///显示错误信息

} 

Answer 1

好象data source=????不对，设置成localhost或者服务器名试一下

Answer 2

Provider=SQLOLEDB 这句改：Provider=SQL SERVER

Answer 3

http://community.csdn.net/Expert/topic/3608/3608767.xml?temp=.710293

Answer 4

hr = m_pConnection->Open("Provider=SQLOLEDB;data source=Yl001;initial catalog=Yl001;userid=sa;password=;","","",adModeUnknown);
--->hr = m_pConnection->Open("Provider=SQLOLEDB;data source=Yl001;persist security info = false;initial catalog=Yl001;userid=sa;password=;","","",adModeUnknown);

Answer 5

不介意的话，代码发给我，我帮你看看：
[email protected]

Answer 6

Timeout时间是不是太短了，把Timeout时间设长一点。

Answer 7

请确认你的SQL Server 可不可以用sa 登录。

Answer 8

hr = m_pConnection->Open("Provider=SQLOLEDB.1;data source=Yl001;persist security info = false;initial catalog=Yl001;userid=sa;password=;","","",adModeUnknown);

Answer 9

//建立连接
_ConnectionPtr g_pConn;
g_pConn.CreateInstance(__uuidof(Connection));
g_pConn->Open ("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Abcd;Data Source=ServerName","","",adModeUnknown);

Answer 10

是不是你data source=Yl001;initial catalog=Yl001这两个搞错了，我用这样就可以：
hr = m_pConnection->Open("Driver={SQL Server};Server=Yl001;database=Yl001;userid=sa;password=;","sa","",adModeUnknown);///连接数据库
Server为服务器地址