MySQL data connection for FastReport.Net
----------------------------------------
How to compile:
---------------
- you need the MySQL .Net Data Provider to be installed. Obtain it
at http://dev.mysql.com/downloads/connector/net/6.0.html;
- open the .sln file;
- fix the "FastReport.dll" reference. By default, this dll is located in the
"C:\Program Files\FastReports\FastReport.Net Demo" folder;
- check that "MySql.Data.dll" reference is correct. If Visual Studio complains about it, fix this reference as well. By default,
this dll is located in the GAC;
- compile the project. You will get the "FastReport.MySQL.dll" file.
How to register this dll in FastReport:
---------------------------------------
You can do it in several ways:
1) register using the FastReport IDE
- open the report designer;
- go "View|Options..." menu;
- on the "Plugins" tab, add the FastReport.MySQL.dll;
- restart FastReport. If you are working in the Visual Studio IDE, restart it as well;
2) edit manually the FastReport.config file
- by default, this file is located in the "C:\Documents and Settings\user_name\
Local Settings\Application Data\FastReport" folder;
- close any running instances of FastReport.Net;
- open the config file in any text editor and modify it in the following way:
<?xml version="1.0" encoding="utf-8"?>
<Config>
...
<Plugins>
<Plugin Name="c:\.....\FastReport.MySQL.dll"/>
</Plugins>
</Config>
3) register the dll programmatically
- add the "FastReport.MySQL.dll" reference to your project;
- execute the following code once at the application start:
FastReport.Utils.RegisteredObjects.AddConnection(typeof(MySqlDataConnection));
How to use it:
--------------
- now you should be able to create a new MySQL data source in the "Data|Add Data Source..." menu.