mfc 用ado连接不上局域网其他电脑的sql2000数据库,不知道如何弄了
mfc 用ado连接不上局域网其他电脑的sql2000数据库,不知道怎么弄了
我的连接函数是这样的,求高手帮我看看哪里的问题
void CTestDlg::OnInitADOConn()
{
try
{
m_pConnection.CreateInstance("ADODB.Connection");
CString strConnect= _T("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User Id=sa;Password=123456;Initial Catalog=大河沿梯级AGC;Data Source=202.114.21.14,1433");
m_pConnection->Open((_bstr_t)strConnect,"","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox("连接数据失败,请检查数据库路径是否正确!");
}
}
------解决方案--------------------
一般不用特意声明1433端口
另外看看你电脑的防火墙1433端口开了没
------解决方案--------------------
::CoInitialize(NULL);
m_pConnection.CreateInstance(__uuidof(ADODB::Connection));
CString strConnect= _T("Provider=SQLOLEDB;Integrated Security=SSPI;Persist Security Info=False;User Id=sa;Password=123456;Initial Catalog=大河沿梯级AGC;Data Source=202.114.21.14;");
我的连接函数是这样的,求高手帮我看看哪里的问题
void CTestDlg::OnInitADOConn()
{
try
{
m_pConnection.CreateInstance("ADODB.Connection");
CString strConnect= _T("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User Id=sa;Password=123456;Initial Catalog=大河沿梯级AGC;Data Source=202.114.21.14,1433");
m_pConnection->Open((_bstr_t)strConnect,"","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox("连接数据失败,请检查数据库路径是否正确!");
}
}
------解决方案--------------------
一般不用特意声明1433端口
另外看看你电脑的防火墙1433端口开了没
------解决方案--------------------
::CoInitialize(NULL);
m_pConnection.CreateInstance(__uuidof(ADODB::Connection));
CString strConnect= _T("Provider=SQLOLEDB;Integrated Security=SSPI;Persist Security Info=False;User Id=sa;Password=123456;Initial Catalog=大河沿梯级AGC;Data Source=202.114.21.14;");