Maya 2009 64bit Doesn't Work With Mysql

Hi,

I have installed SQLAlchemy and it works pretty good with Maya2009 32-bit,
but in Maya2009 64-bit I can't load mysql module.
I got:

import _mysql
# Error: DLL load failed with error code 193
# Traceback (most recent call last):
# File "", line 1, in
# ImportError: DLL load failed with error code 193 #

Any ideas?
Oleg

Hi,
is anybody used MySQL with maya2009?

Maya2009 64-bit

From Maya Scrip editor:
sys.version
# Result: 2.5.1 (r251:54863, Jun 7 2007, 16:23:10) [MSC v.1400 64 bit (AMD64)] #
import _mysql
# Error: DLL load failed with error code 193
# Traceback (most recent call last):
# File "", line 1, in
# ImportError: DLL load failed with error code 193 #

Maya2009 32-bit

From Maya Scrip editor:
sys.version
# Result: 2.5.1 (r251:54863, Jun 5 2007, 22:56:07) [MSC v.1400 32 bit (Intel)] #
import _mysql
_mysql.__version__
# Result: 1.2.2 #

Looks like maya 64bit used [MSC v.1400 64 bit (AMD64)] Python.

you are using a 64 bit mysql then?

I didn't found any python SQL plugin that works in 64 bit. We had to write a C++ plugin to get this to work. This is a pain. If you figure out how to make this work I would like to know how to do it in pure python.

You can compile 64 bit MySQLdb from source code. After compiling this worked great.