I know this is a little late since I'm working from the digest, but we've run CF 5 with Oracle for some time now. CF 5 runs great with any version of Oracle, but drivers can be an issue depending on what platform your Oracle runs on. For example, We run CF 5 on Win2K and Oracle 8i on IBM and on Solaris. We've had great luck with the Oracle 9i client drivers in this situation. We have issues with the Native drivers, that being numeric and date fields returning unreadable characters in the output of "select" queries. We have to "TO_CHAR" those fields to output them. We run with the 9i client installed on our CF server and the ODBC drivers work great.
Hope this helps some, Dave Subject: CF 5 Oracle Best Pactices From: "Robert Shaw" <[EMAIL PROTECTED]> Date: Mon, 24 Mar 2003 16:25:39 -0500 Thread: http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=226 28&forumid=4#114097 I'm about to configure a CF 5 machine and was wondering if anyone knows the best version of Oracle to use with CF 5 - 8.0 vs 8.1.6 or 7 and if I should use native or ODBC. Any insight into best practices or experiences is appreciated - TIA! Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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