Page 1 of 1
R&R 10+ and MySQL 4
Posted: Mon Oct 25, 2004 1:57 pm
by Brian_Craig_(Guest)
I have created a report using an ODBC connection to a MySQL database. The connection is configured properly and has successfully connected to the database. I can choose the table I want, pick the fields, and enter the filter information. When I export the report, the report selection dialog box comes up and counts records read, but doesn^t select any. Also, there are 73 records in the database, and when I stopped it, the report had read 1.2 million.____I am running RR10+ on Windows XP SP1.____Regards__Brian
=> RE: R&R 10+ and MySQL 4
Posted: Mon Oct 25, 2004 3:39 pm
by kfleming
Have you tried using Limit Result Set?____Kathleen__R&R Support
==> RE: R&R 10+ and MySQL 4
Posted: Tue Oct 26, 2004 7:59 am
by Brian_Craig_(Guest)
I have tried limiting the result set to 100 and it doesn^t appear to make a difference. Even if I limit it to 1 and go to ^View Result Set^, the Records Read continuously increment until I cancel the operation.____I am using version 3.51.9 of the MySQL ODBC driver. The driver works ok with another reporting product. I have checked and I am running the latest version of R&R 10+.
===> RE: R&R 10+ and MySQL 4
Posted: Thu Jan 06, 2005 4:45 pm
by StanleySit
I^m also experiencing the same problem. Has a solution to this been found?____Thanks,__Chris