RE: [Zope] Installing MySQL on Windows
Thanks for saving me from spinning in circles. I'm already dizzy from getting my mind around ZPT, Python, ZCatalog and ZClasses! :o) I'll give your suggestion a shot later today. Thanks, Tom P. Allred, MCSE, RHCE, CCNA Allred Data Consulting, Inc. 888-381-0611 www.AllredData.com Tom@AllredData.com -----Original Message----- From: hpinson@indepthl.com [mailto:hpinson@indepthl.com] Sent: Tuesday, November 18, 2003 11:12 AM To: tom@allreddata.com Subject: re: [Zope] Installing MySQL on Windows It's much simpler than that. Use ODBC to connect MySQL to Zope, rather than messing with the Zope native MySQLDA connector, which is somewhat challenging to get working on Windows. Just get the latest MySQL Windows binary installer (currently 4.0.16), install that, and the latest stable MyODBC (3.51). Then get the ZODBCDA Zope Product, untar, install as documented in Products, and restart Zope. The connector should show up on your object menu. Then it's just a matter of adding a connector object and naming the data source. This works really well on Windows. Harlow Pinson Indepth Learning Email: hpinson@indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678
Tom P. Allred wrote:
Thanks for saving me from spinning in circles. I'm already dizzy from getting my mind around ZPT, Python, ZCatalog and ZClasses! :o) I'll give your suggestion a shot later today.
Would it help if you could forget about ZClasses? I recommend it. Go straight for real Products, which use less magic. The mxmEasyProduct package makes this easier. Or if you're using CMF, Archetypes is great. --jcc -- "Code generators follow the 80/20 rule. They solve most of the problems, but not all of the problems. There are always features and edge cases that will need hand-coding. Even if code generation could build 100 percent of the application, there will still be an endless supply of boring meetings about feature design." (http://www.devx.com/java/editorial/15511)
Use ODBC to connect MySQL to Zope, rather than messing with the Zope native MySQLDA connector, which is somewhat challenging to get working on Windows.
Hm, as long as you work with the bundled python, there is a simple solution to getting MySQLDA working on windows and that is to download the MySQL-python-0.9.2.win32-py2.1.exe and *not* install it with the installer, but open it with winzip and extract to your <zopehome>\bin\Lib directory. If you like to do it nicely, move the _mysql.pyd file to the <zopehome>\bin\DLL directory and all should work without problem. That will save you the trouble of making a separate ODBC connection for each mysql database you want Zope to talk to. hth Rik Hoekstra
participants (3)
-
J Cameron Cooper -
Rik Hoekstra -
Tom P. Allred