将 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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 20:50:01  来源:igfitidea点击:

Connecting MySQL with Crystal Reports v10

mysqlvisual-studio-2010crystal-reportscrystal-reports-2008

提问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

enter image description here

在此处输入图片说明

enter image description here

在此处输入图片说明

enter image description here

在此处输入图片说明

回答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 连接器,因为它们有两个:

  1. mysql odbc connector Windows (x86, 32-bit), MSI Installer)
  2. mysql odbc connector Windows (x86, 64-bit), MSI Installer)
  1. mysql odbc 连接器 Windows(x86,32 位),MSI 安装程序)
  2. 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 安装程序

http://dev.mysql.com/downloads/connector/net/

http://dev.mysql.com/downloads/connector/net/