Page 1 of 1
MySQL connection
Posted: Mon Oct 23, 2006 9:36 am
by 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__
=> RE: MySQL connection
Posted: Tue Oct 24, 2006 9:51 am
by 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____
==> RE: MySQL connection
Posted: Thu Oct 26, 2006 4:07 pm
by 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
===> RE: MySQL connection
Posted: Mon Oct 30, 2006 7:42 am
by kfleming
Thank you for the information. This will definitely help other users.____Kathleen__R&R Support
====> RE: MySQL connection
Posted: Tue Nov 14, 2006 2:20 pm
by AprilGef
Thanks Rocky....I had the same problem and found your solution in 2 minutes. You saved me tons of time. Take care.