ADO MYSQL怎么不能连上非本机数据库呢?本地操作没问题!!
语句:
HRESULT hr;
try{
hr=mydb.CreateInstance(__uuidof(Connection));
if(SUCCEEDED(hr))
{
//mydb->Open("Data Source=192.168.8.161; UID="";PWD=""","","",-1);
mydb->Open("Provider=MSDASQL.1;Persist Security Info=False;Data Source=192.168.8.103","","",adModeUnknown);
}
}
catch(_com_error e)
{
CString errormessage;
errormessage.Format("连接数据库失败!\r\n错误信息:%s",e.ErrorMessage());
AfxMessageBox(errormessage);
}
语句:
HRESULT hr;
try{
hr=mydb.CreateInstance(__uuidof(Connection));
if(SUCCEEDED(hr))
{
//mydb->Open("Data Source=192.168.8.161; UID="";PWD=""","","",-1);
mydb->Open("Provider=MSDASQL.1;Persist Security Info=False;Data Source=192.168.8.103","","",adModeUnknown);
}
}
catch(_com_error e)
{
CString errormessage;
errormessage.Format("连接数据库失败!\r\n错误信息:%s",e.ErrorMessage());
AfxMessageBox(errormessage);
}
myset.CreateInstance("ADODB.Recordset");
sql="select * from nmc";
i=myset->Open((LPCTSTR)sql,mydb.GetInterfacePtr(),
adOpenDynamic,adLockOptimistic,adCmdText);
执行到这里就报错了!
provider 有错误。不是MSDASQL,
你应该用MYSQLODBC
OK?