Brent, You absolutely can use standard JDBC drivers to connect with your Oracle database. You could even use JDBC-ODBC bridge drivers, though I wouldn't recommend it. I believe Oracle has a JDBC driver jar for download (is that the thin client?), and there are a couple on sourceforge. You could also go to DataDirect, who provides the underlying drivers for ColdFusion (they're not cheap, I hear).
I haven't done this with Oracle, so I don't know how easy it will be for you. Try them all, benchmark them and check your app for errors. If you find one is better than the rest, share with us. :) On Wed, Apr 30, 2008 at 10:26 AM, Brent Nicholas <[EMAIL PROTECTED]> wrote: > Howdy all, > > At my last place of work we always used the standard version from 4.5 to > MX7, ran seven servers with a common code base in various locations around > the world, the database (Oracle 9i) was always in the same building as the > server and used the java based thin client db connector (classes12.jar). > > Anway, now I work somewhere else and we currently run CFMX7-Enterprise for > a 300 client intranet and resonably low volume public web site. We also run > Oracle 10g, so the built in drivers are nice, however I feel it's total over > kill to run enterprise. > > We're putting in an extranet server, again not with huge utilization. It > will also connect to an Oracle 10g db. > > So I'm wondering, can you still use the java based thin client > (classesXX.jar) between CF and Oracle10g without problems? > > Anoyone have any other thoughts as to why I might want the enterprise vs. > standard. I've always found them to be the same minus a few 'nice to haves' > that we never missed. The Adobe site says there is a performance > difference?? > > Thanks for your time, > BN > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
