4,011
社区成员
发帖
与我相关
我的任务
分享
_bstr_t strConnect="Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=KuanGou;Data Source=192.168.2.64, 1044";
BOOL CADODataBase::SetConnectStr( const std::string& sDataSource, const std::string& sUserId, const std::string& sPassWord )
{
// 初始化COM,创建ADO连接等操作
AfxOleInit();
m_pConnection.CreateInstance(__uuidof(Connection));
try
{
_bstr_t strConnect="Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=KuanGou;Data Source=192.168.2.64";
m_pConnection->Open(strConnect,sUserId.c_str(),sPassWord.c_str(),adModeUnknown);
}
catch (_com_error&e)
{
AfxMessageBox(e.ErrorMessage());
return FALSE;
}
return TRUE;
}
void CDataBaseOper::SetConnectStr( const std::string& sDataSource, const std::string& sUserId, const std::string& sPassWord )
{
m_ConnectStr = "DSN=" ;
m_ConnectStr += sDataSource ;
m_ConnectStr += ";UID=" ;
m_ConnectStr += sUserId ;
m_ConnectStr += ";PWD=" ;
m_ConnectStr += sPassWord ;
}
if( m_db.IsOpen()==FALSE )
{
try
{
m_db.OpenEx( m_ConnectStr.c_str(),CDatabase::noOdbcDialog|CDatabase::openReadOnly );
}
catch (CException*e)
{
e->ReportError();
e->Delete();
return false;
}
}
CRecordset rec( &m_db ) ;
try
{
rec.Open( CRecordset::forwardOnly , m_Sql.c_str() , CRecordset::readOnly ) ;
}
catch (CException*e)
{
e->ReportError();
e->Delete();
return false;
}