after days of fighting with microsoft compilers I was finally able to compile a driver.
Andy posted it 10hrs ago and it has already been downloaded 19 times! not like the lastest hit on youtube but still a lot.
This was build agains mysql 4.1.18
Please let me know about success stories running it since all i did was a small test.
about the build process other then having to install half of microsoft tools, i had to patch some things on setuptools, and work around a REALLY nice bug with cmd/cl/python/includes/and how knows what else that ended up being a couple of "" being strip, thanks Juan (my local C guru) and Andy for helping me undestand this and figuring out a way to solve it (a 2 char patch) which I'll have to post too.
if someone is already pass the dependancy hell that patch is in setup.py adding a r to the part where the compile includes are append, do a search for -dversion and make that a raw string, sorry for behing inacurrate but I got that code at the office.
About how to build it. I'll have to clean up the process and figure out which parts actually work and which where steps not needed, so I wont promise anything but i'll try post a howto.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I don't suppose there's any chance you got the embedded version of MySQL 4.1.x to work with MySQL for Python on Windows.
I really need it. I got MySQL for Python 1.20 working on the Mac with both embedded and server-based MySQL 4.1, and with server-based MySQL 4.1 on Windows, but I reached my technical limits and could never get any MySQL for Python to work on Windows with embedded MySQL 4.1.x.
If you can get this resolved, I'd be most grateful.
David Woods, Ph.D.
Transana Lead Developer
Wisconsin Center for Education Research
University of Wisconsin, Madison http://www.transana.org
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have never use embedded, but I know about the site.cfg will changing this work with the same std 4.1 instalation or I need another mysql package then the std distro?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The MySQL 4.1.x for Windows distributions I looked at include the embedded libraries. MySQL 5.x does not, though you might be able to build them yourself if you compile your own MySQL.
I got everything working with MySQL for Python 1.2.0 and embedded MySQL 4.0.x, but after several days of effort I gave up on embedded MySQL 4.1 on Windows. I really need MySQL 4.1's utf-8 capabilities, but couldn't make it work no matter what I tried.
I'm hoping someone who is more technically skilled than I will be able to solve the problems that stopped me.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello everyone
after days of fighting with microsoft compilers I was finally able to compile a driver.
Andy posted it 10hrs ago and it has already been downloaded 19 times! not like the lastest hit on youtube but still a lot.
This was build agains mysql 4.1.18
Please let me know about success stories running it since all i did was a small test.
about the build process other then having to install half of microsoft tools, i had to patch some things on setuptools, and work around a REALLY nice bug with cmd/cl/python/includes/and how knows what else that ended up being a couple of "" being strip, thanks Juan (my local C guru) and Andy for helping me undestand this and figuring out a way to solve it (a 2 char patch) which I'll have to post too.
if someone is already pass the dependancy hell that patch is in setup.py adding a r to the part where the compile includes are append, do a search for -dversion and make that a raw string, sorry for behing inacurrate but I got that code at the office.
About how to build it. I'll have to clean up the process and figure out which parts actually work and which where steps not needed, so I wont promise anything but i'll try post a howto.
oh I forgot I use mysql 5, i just did 4 to see if the problem was in mysql itself or the driver.
Tomorrow at work I'll build a mysql5 driver and have andy upload it.
I don't suppose there's any chance you got the embedded version of MySQL 4.1.x to work with MySQL for Python on Windows.
I really need it. I got MySQL for Python 1.20 working on the Mac with both embedded and server-based MySQL 4.1, and with server-based MySQL 4.1 on Windows, but I reached my technical limits and could never get any MySQL for Python to work on Windows with embedded MySQL 4.1.x.
If you can get this resolved, I'd be most grateful.
David Woods, Ph.D.
Transana Lead Developer
Wisconsin Center for Education Research
University of Wisconsin, Madison
http://www.transana.org
I saw this while compiling the "normal version"
in site.cfg you need to in line 10
static = True
so down in setup.py there is a little problem :)
line 82,84
if static:
extra_objects.append(os.path.join(
library_dirs[0],'lib%s.a' % client))
as you can see andy here forgot that on windows libraries are .lib :)
I haven't try it if I don't need a special mysql or (if you give me the URL to get the "static" one)
I'll give it a try on monday at work which is where I have my env. setup.
It should be a simple matter of changing site.cfg to use the embedded library, provided that the MySQL Windows packages include it.
I have never use embedded, but I know about the site.cfg will changing this work with the same std 4.1 instalation or I need another mysql package then the std distro?
The MySQL 4.1.x for Windows distributions I looked at include the embedded libraries. MySQL 5.x does not, though you might be able to build them yourself if you compile your own MySQL.
I got everything working with MySQL for Python 1.2.0 and embedded MySQL 4.0.x, but after several days of effort I gave up on embedded MySQL 4.1 on Windows. I really need MySQL 4.1's utf-8 capabilities, but couldn't make it work no matter what I tried.
I'm hoping someone who is more technically skilled than I will be able to solve the problems that stopped me.