mysql odbc connector selects infinitely
-
- Posts: 0
- Joined: Tue Mar 20, 2018 6:34 am
mysql odbc connector selects infinitely
I had to reinstall Windows on my computer (8.1) last week, and am trying to get R&R SQL working again, reading from a MySQL database.__I have created a MySQL ODBC data source that works from within Excel.____But when I try to run a report from R&R SQL it never stops selecting. __I^m running R&R v 12.5, I have tried MySQL connector v 5.1 and v5.3 but it makes no difference.____I even tried created a virtual Windows XP machine and the same thing happens on it. ____If I use SQL Server Native client on a SQL server database, that works fine.____Does anyone have any ideas?__Any help would be greatly appreciated.
-
- Posts: 0
- Joined: Tue Mar 27, 2018 3:43 am
=> RE: mysql odbc connector selects infinitely
Me too. I^m going to try older connectors. __
==> RE: mysql odbc connector selects infinitely
It has checkbox in ODBC setup__Tab : Connection__Enable automatic reconnect __Tab : Misc__Enable safe option (see documentation)____Hope it will help.
-
- Posts: 47
- Joined: Tue Oct 10, 2017 12:44 pm
=> RE: mysql odbc connector selects infinitely
Most versions of R&R attempt to do a cross-join when opening a report to verify that the tables are all present. Depending on the number of tables you have and their size, you might be hit with a significant wait for your report to open.____In some cases, your report might never open because the resultset is so large that it creates a monstrous scratch file. Some servers are smarter than others and handle these joins better.____We^ve recently made some modifications for another customer that addressed this cross-join issue specifically. Let me know if you^d like to test it and I^ll send you a beta version of the program.____The other thing to remember with MySQL is to click "Force use of forward-only cursors" on the Cursors / Results tab.