Page 1 of 1
Report in ASP.NET Web application with MySQL
Posted: Fri Feb 23, 2007 4:32 pm
by dumghe
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!
Report in ASP.NET Web application with MySQL
Posted: Sat Feb 24, 2007 5:07 am
by EDV Gradl
Take a look at the download section:
http://www.stimulsoft.com/downloads.aspx
I hope that helps!
Report in ASP.NET Web application with MySQL
Posted: Sat Feb 24, 2007 3:35 pm
by dumghe
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 ...
Report in ASP.NET Web application with MySQL
Posted: Sat Feb 24, 2007 6:11 pm
by Vital
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.
Report in ASP.NET Web application with MySQL
Posted: Mon Feb 26, 2007 4:09 pm
by dumghe
Ok, fair enough!
I will use the advice you gave me instead of rebuilding the application.
Thanks a lot for your support!
Report in ASP.NET Web application with MySQL
Posted: Tue Feb 27, 2007 4:32 pm
by dumghe
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!
Report in ASP.NET Web application with MySQL
Posted: Thu Mar 01, 2007 4:47 am
by Edward
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.