You might also consider using the MySQL ODBC driver and the Zope ZmxODBC DA. See http://www.mysql.org and http://www.zope.org/Members/djay/ZmxODBC Zope Tips and tricks for Windows NT and SQL =========================================== http://twsite.bizland.com/zopetips.htm

...

...

-----Original Message----- From: f.stefanelli [mailto:filippo@oltrelinux.com] Sent: Monday, September 17, 2001 6:06 PM To: zope@zope.org Subject: [Zope] Disappointment with mysql DA under win

Hi all! My nme is Filippo, I'm a very big newbie of zope and python. Also my english is some kind of newbie stuff. But please listen to me.

The box is a win nt 2000

I have installed: Zope 2.4.1; MySQL server 2.23.39; Python 2.11; after I tryed two ways: a) mysql-python-0.9.0.win32-py2.1.exe; egenix-mx-extension; zmysqlda 2.0.8 the installation dir for the first two is c:\python21

with this I get this error after zope restart (there is the image of a brokenproduct: zmysqlda):

Import Traceback Traceback (most recent call last): File "C:\PROGRA~1\Zope\lib\python\OFS\Application.py", line 558, in import_product product=__import__(pname, global_dict, global_dict, silly) File "C:\PROGRA~1\zope\lib\python\Products\ZMySQLDA\__init__.py", line 91, in ? import DA File "C:\PROGRA~1\zope\lib\python\Products\ZMySQLDA\DA.py", line 92, in ? from db import DB File "C:\PROGRA~1\zope\lib\python\Products\ZMySQLDA\db.py", line 89, in ? import _mysql ImportError: No module named _mysql

I think that this kind of problems are for the incorrect use of c:\python211 instead of c:\zope\bin but how can I tell to the installer of the two products (mysql-python and egenix) to use the zope bin dir? The only choice possible where c:\python211

So I tried another way: b) I download the source of mysql-python (mysql-python-0.9.0) and distutils 1.0.2. I set the path to c:\zope\bin and i do: python setup.py install (for distutils) and python setup.py build (for mysql-python) at this point after some lines there is an error it says that cannot find cl.exe (I also try to search on hard disk for cl.exe, but nothing)and exit...

I'm really hopeless... what steps should I take? Where I'm wrong ?

All this stuff goes great at my linux box at home but on windows I get all this errors. Please help me, I don't know where to look :-(

I promise to write an howto in italian when all is ok :-)

Thanks in advance! Filippo

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )