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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
