Problem in ZOPE-MySQL connectivity..dll mismatch problem
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
On Tue, Apr 23, 2002 at 04:19:43PM +0530, Surajit Sengupta wrote: | 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'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. You have installed a MySQLdb that was compiled with python 2.0 and you are trying to use it with python 2.1. As you've seen, that doesn't work. | I don't know what to do You need to install a version of the extension module that was compiled against the same version of python that you are using. | Help required Either search the web for a ready-made binary or go buy MSVC and compile it yourself. Alternatively install the MySQL ODBC driver and use the Zope ODBC product instead. HTH, -D -- Q: What is the difference betwee open-source and commercial software? A: If you have a problem with commercial software you can call a phone number and they will tell you it might be solved in a future version. For open-source sofware there isn't a phone number to call, but you get the solution within a day.
participants (2)
-
dman -
Surajit Sengupta