Heh :) I should clarify why i told Jerz not even bother :) Well, I remember pulling my hair out in frustration when the time came for me to use Oracle in CFMX. I found that unless I had the enterprise edition of cfmx I had to manually tell CFMX how to connect to the oracle datasource. We eventually nutted it out after lots of reading and alike.
In my travels lurking the net for a solution, I did see allot of people pissing and moaning about how frustrating it was to connect Oracle with CFMX. Whether this is due to lack of knowledge is another debate, all I'm stating to Jeremy and having known Jeremy is its a painful process if you're not an Oracle savvy person. Scott. One thing pisses me off the most is, Its available in the Enterprise edition (and in all honesty it was easy to setup), yet in Professional its not? Why the hell MM "Mark Blair" <[EMAIL PROTECTED]> wrote in message news:22462@cfaussie... > > > 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/
