MySQL-Python 1.0.0 for win32 Notes:
June 28 2004
I needed to get mysql-python working for win32, so I compiled it. I
know
a lot of people are looking for this, so enjoy... With 0.9.2, BLOBs
weren't working properly for me, ZMySQLDA wasn't working
without being patched
and transaction support ( using the + ) wasn't working. This
version resolves all those issues and works for me on
XP/Plone2.03/Zope2.7. However, you should consider it
untested/unsupported,
so use at your own risk.
Installation Notes:
There is no
installer - extract and put the files in your Python\Lib\site-packages
directory.
Compile notes:
Linked against
MySQL 4.0.17 & Python 2.3.3
How to compile on Windows:
Requirements:
MS Visual C++ 6.0
Python 2.3.3 or newer
MySQL 4.0.17 or newer
Quick
Build HOWTO
1. Optional: Get
mingw/gcc. You may need it to build .def or .a files
2. Make sure you
have all the lib files - zlib, msvcrt, crypt32 &
mysqlclient.lib
3. Modify
setup.py for your include&lib paths; also change libraries.append("crypt") to libraries.append("crypt32")
4. Compile from the command line in MS VC++ 6 (needed since Python
& MySQL both use this tool)
C:\Program Files\Microsoft Visual
Studio\VC98\Bin\VCVARS32.BAT (set vc++ paths)
c:\[..\build-dir]> set
PATH=%PATH%;[python-dir]
c:\[..\build-dir]> python
setup.py build
Credits:
Andy's work -
http://sourceforge.net/projects/mysql-python/
*rant - It is unfortunate that you need to compile this in MS Visual C
rather
than with gcc/mingw. I wasted a lot of time trying to get it to link in
gcc before giving up in disgust and grabbing an old VC++ from work. oh
well...
--Aaron Fosdick -- aaron /lkj/
at /87%\/ hypervision.com