I've used "MySQL for Python" in the past to embed MySQL 4.0.24 and earlier in a complex Python application. (See
http://www.transana.org.) I now need to add Unicode support, so need to move to MySQL 4.1.15 or MySQL 5.0.x. I've gotten it working on the Mac, and I've gotten my server-based version working, but unfortunately I've been unable to get MySQL for Python to work with the embedded version of MySQL 4.1.15 on Windows. The MySQL for Python folks are singularly unhelpful regarding Windows problems, so I'm putting the question out here because I'm desperate.
Has anyone gotten the embedded version of MySQL 4.1.x or MySQL 5.0.x to work with Python on Windows, with or without MySQL for Python? When I try, I get a linker error saying there's an "unresolved external symbol _mysql_set_server_option@8". An exact description of what I do is at
http://www.transana.org/developers/setup/MySQLPython_Win.htm, except that I'm substituting MySQL 4.1.15 for MySQL 4.0.25.
Can anyone help me out with this?
Thanks in advance,
David Woods, Ph.D.
Wisconsin Center for Education Research
University of Wisconsin, Madison
http://www.transana.org