Visual C ++ 2010连接到MySQL

I've spent the last 4 days trying to accomplish the following task: - create a MySQL Database - connect to the database in a c++ win32 application so I can use the data and/or edit the data.

我花了最近4天尝试完成以下任务: - 创建一个MySQL数据库 - 连接到c ++ win32应用程序中的数据库,这样我就可以使用数据和/或编辑数据。

So far so good, I'm using the following: - Packard Bell with 64bit Windows 7 Home Edition - Visual C++ Express 2010 - Downloaded and installed mysql 5.5 (choosing the complete installation)

到目前为止,我正在使用以下内容: - Packard Bell与64位Windows 7家庭版 - Visual C ++ Express 2010 - 下载并安装mysql 5.5(选择完整安装)

I have no problems using the mysql terminal and creating a simple Database, however establishing a connection to it in my c++ code is a major hurdle. Some tutorials, forums etc. recommend connecting directly and others suggest using ODBC. The first suggestion leads to a ton of issues with Visual Studio not being able to find source files when including header files: mysql_connection.h

我使用mysql终端并创建一个简单的数据库没有问题,但是在我的c ++代码中建立与它的连接是一个主要障碍。一些教程,论坛等建议直接连接,其他建议使用ODBC。第一个建议导致Visual Studio在包含头文件时无法找到源文件的大量问题:mysql_connection.h

cppconn/driver.h

cppconn/exception.h

etc...

could not find the solution for these issues so I turned to ODBC and found the following code:

找不到这些问题的解决方案所以我转向ODBC并找到以下代码:

(see next post, was not allowed to post more than 2 links)

(见下一篇文章,不允许发布超过2个链接)

The code actually compiles but can't find anything. See screen below: http://imageshack.dk//viewimage.php?file=/imagesfree/CD525364.jpg

代码实际上编译但找不到任何东西。见下面的屏幕:http://imageshack.dk//viewimage.php?file = / imagesfree / CD525364.jpg

I can't find the solution for the problem. This ODBC Data source "mysql" has been set up manually as shown below: http://imageshack.dk//viewimage.php?file=/imagesfree/WEG25517.jpg

我找不到问题的解决方案。此ODBC数据源“mysql”已手动设置,如下所示:http://imageshack.dk//viewimage.php?file = / imagesfree / WEG25517.jpg

I've read the official mysql documentation for setting up visual studio with the right directories and libraries and since the code compiles that can't be the problem right?

我已经阅读了官方的mysql文档,用于设置具有正确目录和库的visual studio,并且因为代码编译不成问题对吗?

I would really appreciate any help or suggestions :) thanks in advance.

我真的很感激任何帮助或建议:)提前感谢。

1 个解决方案

#1

Have you configured your project properties? I am assuming that you've installed MySQL at C:\MySQL

您是否配置了项目属性?我假设你已经在C:\ MySQL安装了MySQL

Open visual studio --> Solution Explorer --> Right Click --> Properties --> C/C++ --> General --> Add Include Directories --> Click to edit and write C:\MySQL\include (or where ever you've installed MySQL and locate its include folder).

打开visual studio - >解决方案资源管理器 - >右键单击 - >属性 - > C / C ++ - >常规 - >添加包含目录 - >单击编辑并编写C:\ MySQL \ include(或其中)你有没有安装MySQL并找到它的include文件夹)。

Now in same properties dialog navigate to Linker --> General --> "Add additional Library Directories" --> (write the path of folder which contains .dll or .lib files e.g. C:\MySQL\Connector ODBC)

现在在相同的属性对话框中导航到链接器 - >常规 - >“添加其他库目录” - >(写入包含.dll或.lib文件的文件夹的路径,例如C:\ MySQL \ Connector ODBC)

In same properties dialog navigate to Linker --> Input --> Additional Dependencies --> (write the name of .lib file you want to use e.g. libmysql.lib or any other library you want to use which is placed in above "Additional Libraray Directories").

在相同的属性对话框中导航到链接器 - >输入 - >附加依赖项 - >(写入要使用的.lib文件的名称,例如libmysql.lib或您要使用的任何其他库,位于上面“附加Libraray目录“)。

Hope it will help you.

希望它会对你有所帮助。

1 个解决方案

#1

更多相关文章

随机推荐