MySQL connection

We welcome your comments, suggestions and feedback for future R&R releasees.
Post Reply
Rocky_V_(Guest)
Posts: 4
Joined: Tue Oct 10, 2017 12:44 pm

MySQL connection

Post by Rocky_V_(Guest) » Mon Oct 23, 2006 12:33 pm

I have R&R Report Writer ver 11. I downloaded and installed the MySQL 3.51 driver and connected to the MySQL server. When I create a report when connected to the MySQL database, my report returns zeros in all the fields. It has an infinite number of pages. The test database contains 6 valid records. Any help would be appreciated.__Rocky__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: MySQL connection

Post by kfleming » Tue Oct 24, 2006 9:50 am

The problem is indeed on the R&R side. We are not correctly interpreting the ODBC data that is being returned by the driver, hence the misbehavior.____A workaround would be to connect through something like Access, download the data to a local database and then use R&R to report against that data.____Kathleen__R&R Support

Rocky_V_(Guest)
Posts: 4
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: MySQL connection

Post by Rocky_V_(Guest) » Thu Oct 26, 2006 4:09 pm

I discovered another work around. On the "Advanced" tab of the ODBC connection, under the tab heading "Flags 1", select the check box titled "Safe" and then the correct results are returned.__Rocky____

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: MySQL connection

Post by kfleming » Mon Oct 30, 2006 7:32 am

Thanks much for the information. This will definitely help other users.____Kathleen__R&R Support

Post Reply