[Zope] odbc da for zope on linux
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:
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
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
> 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
> 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