Cannot retrieve fields when using MySQL DB

mmurdock · Post by **mmurdock** » Tue Aug 26, 2008 5:45 pm

When I press the "Retrieve Columns" button on the "Edit Data Source" screen my columns do not appear. I can click the "View Query" button and the results of my query do show up. When I try to use the 2007.1 version of reports.net it works properly. I can retrieve the fields save the report and then open the report in 2008.1 and the report will run fine except I cannot retrieve new fields if I change the sql statement. I am using the current Mysql connector that is on the website. Below are my version numbers. If I open the same report

MySql.Data 5.2.1.0
Stimulsoft.Base 2008.1.200.0
Same for all other stimulsoft controls

Stimulsoft.Report.MySqlDatabase 2008.1.200.0

Visual Studio 2008

Thanks,

Mat Murdock

Post by **Edward** » Thu Aug 28, 2008 5:23 pm

Hello, Mat.

The issue with Retrieving Columns with 2008.1 is confirmed. We fixed this bug in prerelease versions of Stimulsoft Reports.Net starting from May. All prerelease versions which are available starting from May he 6th must work correctly and with Retrieving Columns option.

Thank you.

mmurdock · Post by **mmurdock** » Wed Sep 03, 2008 2:13 pm

Ok, I have updated my controls to the following version:

MySql.Data 5.2.1.0
Stimulsoft.Base 2008.2.273.0
Same for all other stimulsoft controls

Stimulsoft.Report.MySqlDatabase 2008.2.273.0

I still not able to retrieve columns. I can still see data when I click the View Query button.

Thanks,

Mat

mmurdock · Post by **mmurdock** » Mon Sep 08, 2008 1:23 pm

Any help on this?

Thanks,

Mat

mmurdock · Post by **mmurdock** » Mon Sep 29, 2008 2:49 pm

Post by **Edward** » Mon Sep 29, 2008 3:42 pm

Hello, Mat.

Please download adapter which resolves the issue with retrieving columns.

Sorry, it took time.

Thank you.

mmurdock · Post by **mmurdock** » Mon Sep 29, 2008 3:57 pm

That seems to do the trick. Thanks,

Mat

Post by **Edward** » Tue Sep 30, 2008 3:16 am

Please let us know if any help is required.

Thank you.