Report in ASP.NET Web application with MySQL

dumghe · Post by **dumghe** » Fri Feb 23, 2007 4:32 pm

Hi,

I’m developing an ASP.NET web application that is using MySQL as database server and StimulReport.NET for generating the reports.
After watching the Flash tutorials, I’ve tried to design such a report but I’m not sure how is possible to create a “New Database ... “ as there is no database type for MySQL ADO.NET data provider.

Is it possible to give me a hint what approach is better to be able to use the designer?
Do you think that using the OleDB or ODBC connection would help?
What is the use of "MySQL Database pack"? Does it have any effect on the designer?

The application is implemented to use the MySQL ADO.NET data provider and this is something will not change.

Thank you very much in advance!

EDV Gradl · Post by **EDV Gradl** » Sat Feb 24, 2007 5:07 am

Take a look at the download section:

http://www.stimulsoft.com/downloads.aspx

I hope that helps!

dumghe · Post by **dumghe** » Sat Feb 24, 2007 3:35 pm

Thanks for the answer!
But as you can see in my message, I checked already the pack for MySQL DB.

The readme file that comes with that pack is not that clear, at least to me.
The only solution that I tried and it's working was to include the MySQL DB pack in the StimulReport source code, change the code of the designer (add 2 lines) and recompile it.
The new Designer.exe will show the MySQL Connection option, but doesn't seem the right solution for me.
I have different expectations from a commercial reporting solution ...

Post by **Vital** » Sat Feb 24, 2007 6:11 pm

Sorry, but we can't include direct support of MySql to StimulReport.Net.Why?
1. Our customers can use different versions of MySql providers;
2. MySql provider is third-party components.

To add MySql adapter to report designer you can create Stimulsoft.Report.config. You can create this file with help of Configurator.exe.
Create new configuration. After then add assembly Stimulsoft.Report.MySqlDatabase.dll to configuration and save this configuration to folder where placed
Designer.exe.

Thank you.

dumghe · Post by **dumghe** » Mon Feb 26, 2007 4:09 pm

Ok, fair enough!
I will use the advice you gave me instead of rebuilding the application.

Thanks a lot for your support!

dumghe · Post by **dumghe** » Tue Feb 27, 2007 4:32 pm

Hi,

It's me again!

I tried what you mention:
1. Start Configurator.exe and click on File -> New
2. Click on Edit -> Add Services and select the file "Stimulsoft.Report.MySqlDatabase.dll" (built according to the readme.txt file from MySqlDatabase pack)
3. Two services appear as checked (StiMySqlDatabase and StiMySqlAdapterService) in Select Service dialog. Click Ok in this dialog.
4. Click File -> Save as and create a config file named 'Stimulsoft.Report.config' under 'C:\Program Files\Stimulsoft\StimulReport.Net\Bin' where Designer.exe is installed.
5. Close Service Configurator and start Designer.exe.
6. If I go to Dictionary panel in the right and click on New Item -> New Database I still do not see MySql Connection.

Are these the steps you indicated?
Thanks in advance!

Post by **Edward** » Thu Mar 01, 2007 4:47 am

Please also do not forget to place the following dlls before you launch designer:
Stimulsoft.Report.MySqlDatabase.dll
MySql.Data.dll

to the Designer.exe folder (or to the folder with your Application if you run report designer from there).

Example of the file with MySQL Database support you can download here:
http://forum.stimulsoft.com/upload/Stim ... Config.zip

Thank you.