[Zope] odbc da for zope on linux

[Bobb]

my 2cents...
we use access to front end mysql (hopefully not for long).  The character
sets in access wreak havoc for us in our database.  Between special
characters, and M$ wanting to control spelling, etc. , it's a (boardline)
nightmare.  If you HAVE to front end mysql w/ access, I'd put all input /
edit fields in a courier font.  This seems to help view all of the garbage
that can be placed in the database.

Bobb
----- Original Message -----
From: "andy" <andy@bigorangelovebus.net>
To: "Wade Leftwich" <wade@lightlink.com>
Cc: <Zope@zope.org>
Sent: Thursday, March 13, 2003 5:43 AM
Subject: Re: [Zope] odbc da for zope on linux


> 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.
>
> Andy
>
> 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
> >
> >
>
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
>