I've found bugs with the Oracle odbc drivers (version 8.1.7.0). With some data I'd get cursor errors. After upgrading to MX and using native jdbc drivers, I am no longer experiencing these errors. I suggest you use native drivers- the ODBC drivers were buggy for me. Also, 8.1.7.0 is a good idea because for reasons stated below.
-----Original Message----- From: Lincoln Milner [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 4:46 PM To: CF-Talk Subject: RE: CF 5 Oracle Best Pactices Well, from an Oracle standpoint, 8.1.7 is the only RDBMS that is still supported by Oracle (except under their extended contracts). 9i offers some good things with administration tasks, but, if you're interested in an 8x solution, my vote would be 8.1.7. As far as native vs. OBDC, I would use Native, since I remember (at least back in the days of CF 4.01) that Native drivers were faster than ODBC. That may be different now, but I always try to use native if available. FWIW, -lincoln -----Original Message----- From: Robert Shaw [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 4:26 PM To: CF-Talk Subject: CF 5 Oracle Best Pactices 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4