Hey Robert,

I managed to get it all going yesterday evening. It turns out it is not too difficult doing it this way (figuring it out was the hard part) (assumes Zope 2.3 and MySQL 3.23.33 are currently installed on Windows 2000):

1) Install Python 1.5.2 but use the bin directory in your Zope base directory as the destination path. (Where python.exe resides). This essentially adds the python components that are needed by Distutils that are not distributed as part of Zope 2.3.

2) Install ZMySQLDA-2.0.4 using standard Zope product install procedure.

3) Install Python Distutils (Distutils-1.0.1.win32.exe) http://www.python.org/sigs/distutils-sig/download.html . (Launch the Distutils exe rather than extractng 1st.) This is required for step 4. This is also why I did step 1, to allow Distutils to install properly.

4) Install MySQLdb 0.3.3 using the Windows Installer package at http://highqualdev.com/ (link from page http://dustman.net/andy/python/MySQLdb).

5) From a Python cmdline type "import _mysql".

6) Restart Zope.

So far everything sems to work very well. Much faster and secure than using Access as a backend database. (MS SQL Server not an option due to price constraints).

Thanks,

David

----- Original Message -----

From: Robert Rottermann

To: David Parker

Sent: Sunday, March 04, 2001 12:02 AM

Subject: Re: [Zope] ZMySQLDa and Win32

Hi David,

I did install mysql for zope on an nt 2000 box.

It's a coupple of weeks ago and I did not keep any notes so what I tell you is wat my stak overflow riddlel brain remembers.