logo
small logo
  • Products
  • Buy
  • Support
  • Articles
  • Customer panel Support
    • en
    • ru
    • pt
    • es
    • de
    • pl
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • Connecting to MySQL DB from the report
  • Connection to NosDB (NoSQL)

    November 11, 2019

    NosDB is a prominent representative of the NoSQL databases. It is designed for use on

    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 OracleDB from FastReport .NET

    November 15, 2019

    First of all, you can use the ODBC connector. But it is fraught with a

    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 download buy
avatar
Dmitriy Fedyashov
Head of QA
.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
  • Ticket system
  • FAQ
  • Tutorial Video
  • Forum
  • Articles
  • Our News
  • Press about us
  • Resellers
  • Our team
  • Contact us

© 1998-2021 by Fast Reports Inc.

  • Privacy Policy