Embedded MySQL on Windows - Instructions & ??

[David Woods]

After much struggle to get MySQL for Python working with embedded MySQL on Windows, I have written detailed instructions, which I have posted at:

http://www.transana.org/developers/setup/MySQLPython_Win.htm

I plan to update these instructions as necessary, at least as long as I continue working on the Transana project using this technology.

The current instructions work for MySQL 4.0.25 and MySQL for Python 1.2.0. Unfortunately, I need to use MySQL for Python 1.2.1c3, as I need the Unicode bug fix in this latest beta release, and I need to use MySQL 4.1.14 for its Unicode enhancements in this latest release. I have been unable to get MySQL for Python working with embedded MySQL if I substitute MySQL versions or if I substitute MySQL for Python versions. In both cases, the connection to the database fails with no error message.

If anyone can help me figure out how to get things working with later versions of MySQL or MySQL for Python or both, not only will I be eternally grateful, but I will also update my instructions so that others can also benefit.

I know you don't do Windows, Andy, but I must, like it or not. Hopefully someone will help me figure out where I'm going wrong.

Thanks in advance for your assistance.

[David Woods]

Instructions for how to build MySQL for Python 1.2.1c3 with embedded MySQL 4.0.25 and with server-based MySQL 4.1.14 on Windows are posted at:

http://www.transana.org/developers/setup/MySQLPython_Win.htm

Since my last post, I determined that it is necessary to delete the MySQL for Python build folder, as previous build attempts can sabotage a current build attempt. Or perhaps it is that one form of build can interfere with the other.

I'm still trying to get MySQL for Python with embedded MySQL 4.1.14 working on Windows. During the "build" step, I get the following error message:

_mysql.obj : error LNK2001: unresolved external symbol _mysql_set_server_option@8
build\lib.win32-2.3_mysql.pyd : fatal error LNK1120: 1 unresolved externals error: command '"C:\Program Files\Microsoft Visual Studio\VC98\BIN\link.exe'" failed with exit status 1120

I have no idea what to do with that. Any ideas?

Thanks,
David