[Zope] odbc da for zope on linux

andy andy@bigorangelovebus.net
Thu, 13 Mar 2003 10:43:19 +0000

Thanks Wade & all,

It looks like the easiest way forward is to convert all the databases to 
mysql, front-end them for the users with Access, and use the mysqlda for 
the zope stuff. Only problem I'm having is getting the 
MySQL-python-0.9.0 setup.py file to work. It claims there's no such file 
as distutils.core, even though I can find that file myself.

Any ideas where I'm going wrong? I've got all the databases ready to 
roll, and just need the DA to work. According to my system, the core.py 
file is in /usr/lib/python2.1/distutils/, and the setup.py file in the 
MySQL-python-0.9.0 directory reads:

#!/usr/bin/env python

import os, sys
from distutils.core import setup
from distutils.extension import Extension

If I try to build or install this file, then I get an error saying:

ImportError: No module named distutils.core

Should I be changing some of the setup.py file? I can't see where the 
problem lies...

Thanks in advance for any help.


Wade Leftwich wrote:
> Your Access mdb file is on your Linux box? I don't think you can open it 
> there.
> You'll need to put it on a Windows box, then talk to it via ODBC over
> the network.
> Marc-Andre Lemburg's new and excellent mxODBC Zope Adapter will do the job.
> It's a bargain at $95 per Zope server. I'm using it on Windows, but have
> tested his mxODBC module on Linux, and it works.
> mxODBC enables Python to talk to the ODBC driver manager on your Linux 
> box. There are a couple
> of free ODBC driver mgrs available for Linux. Then for getting your 
> Linux box to talk
> to the Access box, there are one or two free projects as well as 
> commercial products
> (http://easysoft.com/).
> If you don't need to keep the db in Access for other reasons, now would 
> be an excellent time
> to take a good look at PostgreSql.
> You can probably get more answers on the Zope-db list.
> Wade Leftwich
> Ithaca, NY