On 11/8/05, Burns, John D <[EMAIL PROTECTED]> wrote: > The reason I ask is that we currently do some development for sites that > use Oracle and are hosted on navy bases. We currently have a copy of > CFMX 6 Enterprise just for that purpose. We're upgrading to 7 and I'm > curious if we'd need to keep Enterprise or if we could use Standard and > the Oracle drivers without much of hiccup. Obviously, I'm afraid of the > differences and want to keep it close for moving from one server to the > other without problems, but we use pretty standard syntax and don't use > much of Oracle for all that it could be used for. Just basic database > operations. Anyone do this sort of thing and have more info on the > differences? >
If you're upgrading and you are on a maintenance plan, then the upgrade should be free. If you're not on a maintenance plan, there is an upgrade path that is much cheaper than buying a new license. I'd go that route first rather than changing over your driver set. There are indeed differences between the DataDirect and Oracle-distributed drivers. One difference that comes to mind that is cfprocresult doesn't work with the Oracle drivers if you're using any stored procs. There are indeed other differences, and you're likely to save yourself a ton of re-testing time (and money) by staying with Enterprise. Make sure you upgrade to the 3.5 driver set on Macromedia's site. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223595 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
