Jeremy, Don't listen to Scott, he must of been fightin too many US Marines ..
The Sun JDBC/ODBC bridge has terrible performance / stability issues ... Sun are quite open about these ... it should not be used for production ... and even dev/qa will give you problems ... it can offer strange behaviour, especially when dealing with prepared statements and procedures ... sorry Scott, Mark ----- Original Message ----- From: "Jeremy" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Friday, January 31, 2003 5:58 PM Subject: [cfaussie] Re: Oracle and CFMX > Thanks Geoff, > > Got it... > > Jeremy > > > The answer is simple: NO ODBC drivers in either version! > > > > *BUT* supports ODBC through the ODBC/JDBC bridge -- therefore you can > > hook up to just about any ODBC driver (though some limitations may apply) > > > > If you have an ODBC driver for Oracle and you want to connect to it > > through the bridge.. that's fine. But Oracle themselves have their own > > JDBC drivers which you can use for free with Pro instead of the JDBC > > DataDirect drivers supplied with CFMX Enterprise. Hence my reference to > > my blog post :) > > > > -- geoff > > http://cfguru.daemon.com.au/ > > > > Jeremy wrote: > > > Hi Geoff, > > > > > > Thanks for the reply what I was actually after was; Does CFMX support ODBC > > > drivers in the professional edition or do you need to go to CFMX > > > enterprise to use them? > > > > > > J. > > > > > > > > >>Jeremy wrote: > > >> > > >>>I need to quickly know the major pitfalls to look out for when you > > >>>purchase professional vs. enterprise edition of CFMX. > > >>> > > >>>Currently we have many users on Oracle using Native Drivers for > > >>>connectivity to the DB. Can Oracle be used in the professional edition > > >>>using ODBC connection? > > >> > > >>Get Oracle running on CFMX Pro > > >>http://cfguru.daemon.com.au/archives/000078.html > > >> > > >>Also.. there have been a bunch of fixes for Oracle in the updaters.. > > >>read the release notes! Beware updater 2 fixed some things an > > >>introduced other odd issues... updater 3 is rumoured to have more fixes > > >>-- join the beta program to be sure. > > >> > > >>Not to be alarmist... many of the issues are non-events in most > > >>applications. > > >> > > >>-- geoff > > >>http://www.daemon.com.au/ > > > > > > > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
