MySQL connection

[Rocky_V_(Guest)]

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]

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)]

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]

Thank you for the information. This will definitely help other users.____Kathleen__R&R Support

[AprilGef]

Thanks Rocky....I had the same problem and found your solution in 2 minutes. You saved me tons of time. Take care.