Hi, Sheila. The best connectivity between CF and Oracle /based on my own expirience/ - ODBC with Microsoft ODBC driver for Oracle. We have had many troubles with native drivers under load within 2 years, but those troubles disappeared as soon as we switched to ODBC.
Alex. SH> This is my first encounter with Oracle. I need to define a datasource in SH> CF5. As far as using the database, it'll be nothing but the simplest SELECT SH> statements, so that shouldn't be a problem. SH> Is it possible to define an Oracle database with OLEDB, or do I have to use SH> ODBC? Can anyone give me some hints about defining an Oracle datasource? My SH> experience is mostly with Sql Server. SH> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com