[Zope-DB] Interested in continued Oracle support in Zope?

Dario Lopez-Kästen dario at ita.chalmers.se
Thu Aug 26 04:44:31 EDT 2004

Charlie Clark wrote:

> We'd be very interested to know what people's experience with mxODBC and 
> Oracle are and, of course, interested in improving things where possible. 
> Our understanding is that the standard Un*x Oracle ODBC isn't up to much so 
> third party drivers are required. When connecting to Oracle on Windows it's 
> possible for the drivers to work like native ones.

We only use Linux or Solaris in production for our HA services. We have 
a few windows servers, but those are not used for any of the sites that 
need to access or serve Oracle-based data.

 From my perspective, there is a problem in that in order to use ODBC on 
Linux (which we are moving towards for most of our web-apps), I need to 
a) use unixODBC and b) purchase a linux ODBC driver from EasySoft.

This is a cost of about 3000 USD for the whole site (we use several 
machines). Then we have to purchase a similar site license for mxODBC.

Compare this to the fact that we can switch to Java (which would get a 
big Hurrah! from some of the more Buzz-word compliant managers) or PHP, 
which is also favored here.

So, from my own perspective,, it would be way smoother if there was a 
native Python driver for Oracle.

I am not questioning mxODBC or anything, I am just pointing out that the 
decision to use or not use mxODBC is not a simple one.

If it just was about the money, i think it would be no problems, but 
spending almost 4000 dollars (including licenses for mxODBC) and STILL 
having to rely on the non-commercial platform that is unixODBC, sort of 
negates the whole point of spending money on commercially supported 

And this very fact, may lead to choosing other platforms than Zope for 
apps that have to use Oracle. I just cannot justify the problems we are 
having with the Oracle drivers for python. I can only try to maske them 
so much, but as it is now, I may just have to consider Java, Perl or PHP 
based appservers instead.

Something that I do not wish to happen, of course.

-- -------------------------------------------------------------------
Dario Lopez-Kästen, IT Systems & Services Chalmers University of Tech.

More information about the Zope-DB mailing list