[Zope] Zope and MySQL on Windows

[Bryan Capitano]

There are several options to using Zope+MySQL on the same Windows box. I
have not done this in a production server environment, so I can't say how
well that would work. But for development purposes, it works just fine.

I had some problems getting python-MySQL adapter to install on Windows and
recognize my python installation (because I was trying to install MySQLDA).
But there are two ways around this problem which I've learned:
(1) One is to install MyODBC (see www.mysql.com) and create a System ODBC
database for your MySQL database. Then install the MyODBCDA database adapter
for Zope (instead of MySQLDA). This allows you to talk to MySQL through an
ODBC bridge. This solution works like a charm.
(2) The second workaround is to install Python2.1.3 on your machine
separately from the Windows Zope installation. Then install the .exe
Mysql-Python package (www.sourceforge.net). Then copy the installed files to
the Zope/Python directory. Then install MySQLDa. This solution was provided
to me by another list member (hiren_hindocha@attbi.com).



Bryan

Bryan R. Capitano
President,
CAPITANO WEb CONSULTING
Tel: 541-344-0747
Email: Bryan@capitanoweb.com
URL: http://www.capitanoweb.com
-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Greg &
Janet LINDSTROM
Sent: Saturday, November 02, 2002 7:41 AM
To: zope@zope.org
Subject: [Zope] Zope and MySQL on Windows


Greetings-
I have a fairly mature Python application which uses MySQL for the database.
I would like to switch over from a single machine application to a web based
app (and maybe even make some money!!), and thought Zope would be the
logical choice.  The past 2 weeks have had me running through the examples
in the Zope book and the Zope "Bible", and I *think* I am ready to create a
project.  Then I read the the creators of Zope do not reccommend using MySQL
with Zope on a Windows box.  Rats!  So...
   1.  Is this still sound advice?
   2.  If so, what other Open Source Database is out there.  I really would
like data/time data types, so that would leave Gadfly out, right?  Plus. my
database is getting fairly large (~5 Meg), so I'm not sure I want to load it
all in memory.

Thanks for any advice you can supply!
Greg Lindstrom
Vilonia, Arkansas