logo
small logo
  • Products
  • Buy
  • Support
  • About
  • Customer panel Support
    • en
    • de
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • Connecting to MySQL DB from the report
  • How to use DB connectors from the Nuget repository

    May 28, 2018

    FastReport.Net has been supplying plugins for a long time - connectors to various databases. These

    read more
  • How to connect to RavenDB

    November 11, 2019

    Recently, the NoSQL database is gaining more and more popularity. They differ favourably from conventional

    read more
  • How to connect to SQLCe

    November 11, 2019

    Microsoft SQL Server Compact Edition is a simple local relational database that doesn't require installation,

    read more
  • How to connect to VistaDB

    November 15, 2019

    The Vista database will fall into the type of embedded databases. These databases differ from

    read more
  • How to connect to the Sybase SQL Anywhere database

    February 29, 2020

    Sybase SQL Anywhere database has a number of very useful features that make it very

    read more

Connecting to MySQL DB from the report

August 15, 2017

It is known that FastReport.Net can work with almost any database. And quite often the users the question arises, how to connect MySQL database to your report. In this article we will look at the process inside and out, and in two versions:

 1. In the first method, you can use special plugin to connect to the MySQL database. This plug-in is a dll library. To obtain this library, you need to build the project from FastReport.Net delivery. It is located in the folder: FastReport.Net\Extras\Connections\FastReport.MySQL. After assembly in the bin folder you will find FastReport.MySQL.dll library.

Open the report designer. Open the File-> Options menu:

On the Plugins tab add our library by using the Add button. Now restart the designer.

Add a new data source in the report. In the Data Wizard create a new connection:

 

In the list of connection types there is a new one - MySQL connection. Choose it:

Fill the fields and click Ok. In the Data Wizard, select the table from the database “world”. For example, city:

 

Click Finish to complete the wizard. That's all. The obtained data can be used in the report.

 

 2. Consider the second method - use the native connector ODBC Driver for MySQL.

You can download it from the developer - http://dev.mysql.com/downloads/connector/odbc/.

The installation does not cause problems - everything is simple and clear.

Next, run the report designer and create a new report. On the Report tab, add a new data source using the icon .

In the Data Wizard, create a new connection (New connection ...):

In the connection editor, select the type of connection - ODBC connection:

Switch the radio button to "Use connection string:". And press the button  to create a connection string. In this case you will be prompted to select a data source:

 

Click the button "New ...". The wizard of creation data source will be launched:

Choose one of the two available: MySQL ODBC. Ansi or Unicode encodings depends on your database. Click "Next." And set the connection options:

After closing this window, select the created connection in the "Select Data Source" box.

Once again we see the connection settings. Enter your password and click Ok.

Thus we get the customized connection in our Data Wizard:

Click OK. In the wizard, click Next and proceed to the tables selection:

We have considered two ways to create a connection to the database MySQL. The first method is a little more complicated in the beginning, when you want to build a library, but more convenient for subsequent reuse plugin. The second method seemed to me less convenient for subsequent use.

about product buy
avatar
Dmitriy Fedyashov
Technical Writer
Fast Reports Team: Dmitriy Fedyashov - Technical Writer at Fast Reports
.NET FastReport Data Source

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Buy
  • Download
  • Documentation
  • Testimonials
  • How to uninstall
  • FAQ
  • Tutorial Video
  • Forum
  • Support SLA
  • Articles
  • Our News
  • Press about us
  • Resellers
  • Extended licensing
  • Contact us

© 1998-2023 by Fast Reports Inc.

  • Privacy Policy

Trustpilot