【1】下载mysql-connector并解压
静态编译部分
【2】
VS2008 Additional Include Directories 加mysql-connector\include
VS2008 Additional Library Directories 加mysql-connector\lib, C:\Program Files\MySQL\MySQL Server 5.2\bin
VS2008 Additioinal Dependencies 加mysqlcppconn.lib mysqlcppconn-static.lib
动态链接部分
【3】将libmysql.dll(C:\Program Files\MySQL\MySQL Server 5.2\bin目录中)拷贝至C:\WINDOWS\system32目录下
【4】将mysqlcppconn.dll(mysql-connector\lib目录中)拷贝至工程根目录(在【2】中已经设置过lib目录,所以应该可以找到mysql-connector\lib\mysqlcppconn.dll,但是指示找不到,需要这样的拷贝才可以,知道原因大侠请留言哈)