Thanks for the info!!! If I point both servers DSN at the same database, one server is fine, the other fails? Excuse my naivety on the issue....but MDAC is specific to the database, and not the CFserver correct? If so, I can eliminate that as a possibility correct? Both servers are identical CFserver versions, however one the one that fails is on different domain than the dB, the one that succeeds is on the same domain as the db. Is it possible that the infrastructure is causing the failure?
-----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, October 21, 2004 9:48 AM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] macromedia.JDBC: ArrayOutOfBoundsException (Slightly OT) > If you're using an MS database, it could be that you've a > different version of MDAC. I've fixed a couple of our more > heavyweight queries by upgrading MDAC. > > There's a utility that tells you the version on Microsoft's > MDAC home page. I don't think that MDAC will affect queries made from CFMX unless you're using ODBC drivers. The "Microsoft SQL Server" driver provided with CFMX does not use ODBC. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
