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