vb.net VB.NET如何连接Crystal Report和MySQL

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/31467360/
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-09-17 19:17:40  来源:igfitidea点击:

How to connect Crystal Report and MySQL in VB.NET

mysqlvb.netcrystal-reports

提问by Lee Song

To clarify things first, I can connect MySQL to VB.NET. But I can't connect Crystal Report and MySQL. When I'm creating new report in CrystalReportViewer control, I am stucked at the Standard Report Creation Wizard window. I can't see any connections and my database (I created it in MySQL Query Browser).

首先澄清一下,我可以将 MySQL 连接到 VB.NET。但是我无法连接Crystal Report 和MySQL。当我在 CrystalReportViewer 控件中创建新报表时,我被困在标准报表创建向导窗口中。我看不到任何连接和我的数据库(我在 MySQL 查询浏览器中创建了它)。

I'm using: Visual Studio 2010enter image description here, MySQL Query Browser, SQL Server 2005, Crystal Report(CRforVS13_0_13)

我正在使用:Visual Studio 2010 在此处输入图片说明、MySQL 查询浏览器、SQL Server 2005、Crystal Report(CRforVS13_0_13)

Any help? Or am I just missing something?

有什么帮助吗?或者我只是错过了什么?

采纳答案by Rohit Gupta

Crystal Report requires an ODBC driver. You can find one here.

Crystal Report 需要 ODBC 驱动程序。你可以在这里找到一个。

After you have installed it, check that it exists in the ODBC Data Sources.

安装后,请检查它是否存在于 ODBC 数据源中。

It must be visible here.  When I get home, I can instal it and show you hat the text looks like.

它必须在这里可见。 当我回到家时,我可以安装它并向您展示文字的样子。

Once there, you need to create an Alias. Click on the User DSNtab and press the Addbutton. Test the connection then go to Crystal reports.

到达那里后,您需要创建一个别名。单击用户 DSN选项卡并按下Add按钮。测试连接,然后转到 Crystal 报告。