这是我的程序我封装一个类
CDataManage::CDataManage()
{
DataConn.CreateInstance(_uuidof(Connection));
DataRecord.CreateInstance(_uuidof(Recordset));
Record1.CreateInstance(_uuidof(Recordset));
}CDataManage::~CDataManage()
{
DataConn->Release();
DataRecord->Release();
Record1->Release();
}_ConnectionPtr CDataManage::GetConn()
{
return DataConn;
}_RecordsetPtr CDataManage::GetRecordset()
{
return (DataRecord);
}bool CDataManage::ConnectDatabase(CString constr)
{
DataConn->ConnectionString = (_bstr_t)constr;
try
{
DataConn->Open("","","",-1);
}
catch(...)
{
return false;
}
return true;}BOOL CEquipmentApp::InitInstance()
{
::CoInitialize(NULL);
datamanage=new CDataManage();
datamanage->ConnectDatabase(_T("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Equipment;Data Source=MS-24DB17C45272\SQLEXPRESS"));数据库名:Equipment;
服务器名:MS-24DB17C45272\SQLEXPRESS;
可是怎么也连不上清高手那有错误,非常感谢!
CDataManage::CDataManage()
{
DataConn.CreateInstance(_uuidof(Connection));
DataRecord.CreateInstance(_uuidof(Recordset));
Record1.CreateInstance(_uuidof(Recordset));
}CDataManage::~CDataManage()
{
DataConn->Release();
DataRecord->Release();
Record1->Release();
}_ConnectionPtr CDataManage::GetConn()
{
return DataConn;
}_RecordsetPtr CDataManage::GetRecordset()
{
return (DataRecord);
}bool CDataManage::ConnectDatabase(CString constr)
{
DataConn->ConnectionString = (_bstr_t)constr;
try
{
DataConn->Open("","","",-1);
}
catch(...)
{
return false;
}
return true;}BOOL CEquipmentApp::InitInstance()
{
::CoInitialize(NULL);
datamanage=new CDataManage();
datamanage->ConnectDatabase(_T("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Equipment;Data Source=MS-24DB17C45272\SQLEXPRESS"));数据库名:Equipment;
服务器名:MS-24DB17C45272\SQLEXPRESS;
可是怎么也连不上清高手那有错误,非常感谢!
{
AfxMessageBox(e.
}
如果是sqlserver2000+windows2000,需要sp4+mdac2.8
这是什么意思?
我使用ADO 控件得到的ConnectString连接字符并且显示连接成功这里为什么连接不上了
DataConn->CursorLocation = adUseClient;
HRESULT hRet = DataConn->Open(constr.operator LPCTSTR(), "", "", adConnectUnspecified);
服务器名:MS-24DB17C45272\SQLEXPRESS;
可是怎么也连不上清高手那有错误,非常感谢!===========================================================
不支持这样的计算机名中“ - ”,计算机名和服务器名都改为“MS”。
高手指点
作 者: TOUT ()
============================================================ 高手到下面的一个贴子帮看看!指点下,先谢谢了........
datamanage->ConnectDatabase(_T("DSN=Equipment;APP=Microsoft® Visual Studio® 2005;WSID=WRF;DATABASE=Equipment;Trusted_Connection=Yes"));
可是我不到为什么..我没有使用Microsoft OLE DB Provider for SQL Server 生成的连接字符
而是使用Microsoft OLE DB Provider for ODBC Drivers 生成的连接字符.
终于连接上了,非常感谢各位的帮助!!