MFC 怎么用ADO连接Mysql ？？（救命啊，个位大侠）

Question

MFC 怎么用ADO连接Mysql ？？很急，懂的朋友指点一下啊，万分感谢！

Answer 1

http://hi.baidu.com/wenjiejia/blog/item/bf2601f7a93a9526720eec16.html

Answer 2

CString db = "Database=数据库名; uid=登录数据库用户名; pwd=登录数据库密码;";

try
{
// 创建Connection对象
m_pConnection.CreateInstance("ADODB.Connection");
// 设置连接字符串，必须是BSTR型或者_bstr_t类型
_bstr_t strConnect = "Provider=SQLOLEDB.1; Server=127.0.0.1; " + (_bstr_t)db;
m_pConnection->Open(strConnect,"","",adModeUnknown);
}
// 捕捉异常
catch(_com_error e)
{
// 显示错误信息
AfxMessageBox(e.Description());
}

Answer 3

_bstr_t strConnect = "Driver=MySQL ODBC 3.51 Driver;Server=127.0.0.1;Database=数据库名;UID=数据库登陆名;PWD=密码"
HRESULT hr=pConn->Open((_bstr_t)strConnect,"","",-1); 

Answer 4

为什么不用mysql自己的API呢？
http://download.csdn.net/source/503316