You might want to check out this TechNote: http://www.macromedia.com/v1/Handlers/index.cfm?ID=23463&Method=Full
Deb -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 3:03 PM To: CF-Talk Subject: CF4.5 and CFMX Oracle ODBC Drivers Does anybody know what differences there might be between the 4.5 and MX ODBC drivers for a Oracle database. We have a query to the Oracle database the runs just fine on a CF4.5 server, but when we migrated to new CFMX server all of a sudden the query is throwing errors. Both cold fusion servers are pointing the same Oracle database server. It seems to involve a date field. If we try to select the offending field from the MX we get following error. Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Oracle][ODBC]Invalid datetime format. I'm just wondering why the version running on the 4.5 server has no trouble selecting this date field, but that the MX server does? Thanks for any information. Ian Skinner Web developer BloodSource Sacramento, CA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4