Hello,
    I'm using ZOPE Version 2.0, which is using the Python 2.1.2. Now I want to make a connectivity of ZOPE with MySQL.
    I've 
    I'm using in Windows 2000 platform
  1. Downloaded the Python-MySQL Interface(Version 0.9.0) [MySQLdb]
  2. Downloaded the ZOPE MySQL database Adapter (Version 2.0.8) [ZMySQLDA]
  3.  Built MySQLdb(0.9.0)
  4. Installed MySQLdb(0.9.0)
  5. Inflated ZMySQLDA in required directory
 

***Problems found : dll version mismatch

After running the ZOPE server: Following errors are generated

2002-04-23T06:49:32 ERROR(200) Zope Could not import Products.MySQLdb

Traceback (innermost last):

  File C:\PROGRA~1\Zope\lib\python\OFS\Application.py, line 531, in import_product

  File MySQLdb\__init__.py, line 27, in ?

ImportError: Module use of python20.dll conflicts with this version of Python.

 

                Anticipations :

In C:\Program Files\Zope\bin there is python21.dll which I think the latest dll which the python exe of our ZOPE version is using. After putting it to the c:\winnt\system32 and registering it, the same error is coming.  During the run of Zope server __init__ of ZMySQLDA  is importing _mysql.pyd which is generating the error as it is searching for python20.dll(NOT python21.dll). I have a python20.dll also in my c:\winnt\system32, its version also does not match with the python exe our ZOPE version is using.
 
I don't know what to do
 
Help required
 
Regards
Surajit