# Maya 2009 64bit Doesn't Work With Mysql

**URL:** https://forum.highend3d.com/t/maya-2009-64bit-doesnt-work-with-mysql/48811
**Category:** Maya
**Tags:** python
**Created:** [November 7, 2008, 10:39am UTC](https://forum.highend3d.com/t/maya-2009-64bit-doesnt-work-with-mysql/48811 "2008-11-07T10:39:33Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![soeasy3d](https://forum.highend3d.com/letter_avatar_proxy/v4/letter/s/eb9ed0/32.png) [@soeasy3d](https://forum.highend3d.com/u/soeasy3d)
#### Post date: [November 7, 2008, 10:39am UTC](https://forum.highend3d.com/t/maya-2009-64bit-doesnt-work-with-mysql/48811/1 "2008-11-07T10:39:33Z")

</div>

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

---

<div class="post-metadata">

### Author: ![soeasy3d](https://forum.highend3d.com/letter_avatar_proxy/v4/letter/s/eb9ed0/32.png) [@soeasy3d](https://forum.highend3d.com/u/soeasy3d)
#### Post date: [November 10, 2008, 8:41am UTC](https://forum.highend3d.com/t/maya-2009-64bit-doesnt-work-with-mysql/48811/2 "2008-11-10T08:41:41Z")

</div>

Hi,   
is anybody used MySQL with maya2009?

---

<div class="post-metadata">

### Author: ![soeasy3d](https://forum.highend3d.com/letter_avatar_proxy/v4/letter/s/eb9ed0/32.png) [@soeasy3d](https://forum.highend3d.com/u/soeasy3d)
#### Post date: [November 10, 2008, 3:40pm UTC](https://forum.highend3d.com/t/maya-2009-64bit-doesnt-work-with-mysql/48811/3 "2008-11-10T15:40:05Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![joojaa](https://forum.highend3d.com/letter_avatar_proxy/v4/letter/j/5daacb/32.png) [@joojaa](https://forum.highend3d.com/u/joojaa)
#### Post date: [November 25, 2008, 3:50pm UTC](https://forum.highend3d.com/t/maya-2009-64bit-doesnt-work-with-mysql/48811/4 "2008-11-25T15:50:21Z")

</div>

you are using a 64 bit mysql then?

---

<div class="post-metadata">

### Author: ![masternull](https://forum.highend3d.com/letter_avatar_proxy/v4/letter/m/5f9b8f/32.png) [@masternull](https://forum.highend3d.com/u/masternull)
#### Post date: [November 28, 2008, 2:30pm UTC](https://forum.highend3d.com/t/maya-2009-64bit-doesnt-work-with-mysql/48811/5 "2008-11-28T14:30:06Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![soeasy3d](https://forum.highend3d.com/letter_avatar_proxy/v4/letter/s/eb9ed0/32.png) [@soeasy3d](https://forum.highend3d.com/u/soeasy3d)
#### Post date: [December 9, 2008, 7:55am UTC](https://forum.highend3d.com/t/maya-2009-64bit-doesnt-work-with-mysql/48811/6 "2008-12-09T07:55:28Z")

</div>

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