CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
//pConn->Open("DSN=MySource;Server=localhost;database=test;","root","123456",adModeUnknown);//在本机 192.168.3.91上连接本地成功
pConn->Open("DSN=MySource;Server=192.168.3.92;database=test;","myuser","123456",adModeUnknown);
/**/
CoUninitialize();
现在情况是这样的,我在192.168.3.92上授权了myuser用户访问,客户机192.168.3.91通过MySQL Administrator使用myuser账户可以成功登陆到192.168.3.92上,现在问题是192.168.3.91通过MFC中无法登陆。想问题可能存在于Open("DSN=MySource;Server=192.168.3.92;database=test;","myuser","123456",adModeUnknown);这句话中,但不知道怎么改,还请高手赐教~~~
{
CString strConnect = "";
if (strCharset == "")
{
strConnect.Format("Driver=Mysql ODBC 5.1 Driver;Server=%s;DataBase=%s;Port=%d;uid=%s;PASSWORD=%s",strServer,strDatabase,iPort,strUID,strPwd);
}
else
{
strConnect.Format("Driver=Mysql ODBC 5.1 Driver;Server=%s;DataBase=%s;Port=%d;uid=%s;PASSWORD=%s;CharSet=%s",strServer,strDatabase,iPort,strUID,strPwd,strCharset);
}
return Open(LPCTSTR(strConnect), lOptions);
}以上是通过mysql odbc5.1连接的代码,你看一下,希望有帮助
通过mysql动态库的方式有相关API,可能参考
先谢谢啦!