Hi,

we’re using Maya 2011x64 with Microsoft Sql Server at the backend.  I’ve compiled pyodbc64 and been able to connect to our db using MotionBuilder 2011x64, but I don’t know a thing about how to set it up for Maya.

First of all, let me just say I have no idea what I’m doing in Maya.  :-)

I’ve dropped the pyodbc64.pyd in C:\Program Files\Autodesk\Maya2011\Python\Lib\site-packages\maya

If I bring up the script editor in Maya I can do the following with no error:

import pyodbc64
DSN = ‘MyMocapDB’

now if I do the following:

c = pyodbc64.connect( DSN )

Maya spits back:

# Error: Error: IM002 #

Seems like it’s some kind of connection error, but the exact same code works in MotionBuilder. 

Has anyone gotten pyodbc to work in Maya 2011 in a 64-bit environment?  I’m sure someone has, but I can’t find any info via google ...

Thanks!

Hi,

I think Maya was un-able to locate the file.So i request you to check your os.path. Here is an example for connecting MySQLdb with Maya.

http://chrischia.info/blog/?p=8

Thank you