On Mon, Apr 25, 2011 at 4:20 PM, Peter J. Farrell <[email protected]> wrote:
> Which driver are you using for your OpenBD datasource -- I don't think > OpenBD ships with the MS JDBC driver and uses the JTDS driver. There > could be differences between drivers... I'd try swapping them... > Actually OpenBD does ship with the MS driver but you should certainly try swapping the driver if you're using the jTDS driver. And if you're switching drivers make sure to delete the datasource and recreate it since I've seen cases where if the connection is still open it won't actually be using the new driver if you simply edit the datasource and swap drivers. Beyond that, are you LITERALLY using the EXACT same query, meaning NO VARIABLES in CFML, etc.? Only asking because I've dealt with cases in the past where people swore up and down that it was the exact same query, but in actuality they were hard-coding variable values in the test runs in other tools, and the values of variables when they ran it in CFML weren't what they thought they were. If you dump the query after you run it it'll show you the exact SQL it's running so you can compare. -- 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 -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
