Have you tried setting up a fresh install (openbd/mysql) without your existing app, and testing it?
With a fresh install (current drivers) you could test it by sending some basic sql commands.. and work up to trying your code. On Thu, Dec 1, 2011 at 4:25 PM, Tom <[email protected]> wrote: > 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 > -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
