将 MySQL 与 Crystal Reports v10 连接起来
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/7020083/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Connecting MySQL with Crystal Reports v10
提问by sean
I am new to Crystal Reports v10 and I'm creating reports to embed in Visual Studio 2010 forms. The database server I'm using is MySQL. I have some issues regarding to creating new connection in crystal reports. Based on what I've read, I should select the ODBC in order for me to connect it to the MySQL. However, when I select ODBC and LocalServer and enter the username and password an error message occurred and shows Logon Failed. Am I doing it right? Is there anything you could help me please?
我是 Crystal Reports v10 的新手,我正在创建要嵌入到 Visual Studio 2010 表单中的报表。我使用的数据库服务器是 MySQL。我有一些关于在水晶报表中创建新连接的问题。根据我读过的内容,我应该选择 ODBC 以便我将它连接到 MySQL。但是,当我选择 ODBC 和 LocalServer 并输入用户名和密码时,出现错误消息并显示Logon Failed。我做得对吗?请问有什么可以帮我的吗?
I already installed the MySQL Connector/ODBC 5.1
我已经安装了MySQL 连接器/ODBC 5.1
回答by Michael Berkowski
You need to install the MySQL ODBC Connector.. Create an ODBC data source from the Administrative Tools \ ODBC Data sources control panel. It will then be available in Crystal Reports.
您需要安装MySQL ODBC 连接器。. 从管理工具 \ ODBC 数据源控制面板创建 ODBC 数据源。然后它将在 Crystal Reports 中可用。
回答by darktrion
You must download the appropriate version of mysql odbc connector since there are two of them:
您必须下载适当版本的 mysql odbc 连接器,因为它们有两个:
- mysql odbc connector Windows (x86, 32-bit), MSI Installer)
- mysql odbc connector Windows (x86, 64-bit), MSI Installer)
- mysql odbc 连接器 Windows(x86,32 位),MSI 安装程序)
- mysql odbc 连接器 Windows(x86,64 位),MSI 安装程序)
if 64-bit doesn't run, try to uninstall it and try the 32 bit msi Installer
如果 64 位无法运行,请尝试卸载它并尝试 32 位 msi 安装程序