Hi Greg,

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

Do they meant MySQL with Zope on the same Windows box ? But why Windows ? We use always Linux for such a project.

box. Rats! So... 1. Is this still sound advice? 2. If so, what other Open Source Database is out there. I really

PostGreSQL is also a open source I think.

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.

5 MB is not big ! Regards, Dirk

From: "Greg & Janet LINDSTROM" <yuba@cyberback.com> 2. If so, what other Open Source Database is out there. ZODB for example. :-) Now, you probably ment to ask what opse source SQL databases there are. I know of two others: PostgreSQL and Firebird Best Regards Lennart Regebro Torped Strategi och Kommunikation AB

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