为何连接本地的sql server2000都连不上
bborn 2008-06-21 12:52:05 本地的sql server2000 别的程序连接都没问题
一个mfc窗口程序 sql ser 用windows身份验证 和 windows和sql混合验证 都试过了
都连不上 下面是全部代码
#import "c:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF", "EndOfFile")
CoInitialize(NULL);
HRESULT hr;
_ConnectionPtr pConn;
_CommandPtr pCommand;
try
{
//_bstr_t Conn= "Provider=SQLOLEDB;Password=;Persist Security Info=True;User ID=tiger;Initial Catalog=tiger;Data Source=127.0.0.1";
_bstr_t Conn= "SQLOLEDB;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=tiger;Data Source=(local);";
pConn.CreateInstance(_uuidof(Connection));
hr=pConn-> Open(Conn,_bstr_t( " "),_bstr_t( " "),adModeUnknown);
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
errormessage.Format( L"连接数据库失败!\r\n错误信息:%s ",e.ErrorMessage());
AfxMessageBox(errormessage);///显示错误信息
}
CoUninitialize();