Hi Matthew, thanks for your continued help on this.. still banging my head on the desk over here.
Running the query directly on MySQL was the first thing I did (mentioned above) and it works perfectly fine. What would be a quick/free way to test the query via JDBC? No I'm not still using ODBC.. However just for the sake of testing, I just attempted to set it up using ODBC, but I couldn't get the bluedragon administrator to recognize my ODBC database. Anything I would have to do to get this to work? Thanks again. On Dec 1, 5:20 pm, Matthew Woodward <[email protected]> wrote: > On Thu, Dec 1, 2011 at 2:07 PM, Tom <[email protected]> wrote: > > Thanks Matthew.. Unfortunately I'm not sure I can do this. I checked > > the old server, and it was set up using Microsoft ODBC driver 3.51. I > > couldn't find a mysql-connector anywhere on the old server. > > Yeah that's a totally different beast. > > > > > Can anyone confirm they are using the latest version of OpenBD and > > MySQL on Windows and able to use FOUND_ROWS() successfully? > > Have you tried running the query directly in MySQL? The real test would be > to use a tool like Aqua Data Studio that uses the JDBC driver, but even > running the query from a terminal or in the MySQL GUI tool might shed some > light on things. > > And just so there's no misunderstanding, without information to the > contrary OpenBD and even your operating system (you're NOT still using > ODBC, right?) have zero impact on what's going on here. The best > troubleshooting you could do would be to start by running the query against > MySQL directly, preferably using a tool that lets you use the same JDBC > driver so you can see the behavior. > > -- > Matthew Woodward > [email protected]http://blog.mattwoodward.com > identi.ca / Twitter: @mpwoodward > > Please do not send me proprietary file formats such as Word, PowerPoint, > etc. as attachments.http://www.gnu.org/philosophy/no-word-attachments.html -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
