[Maya-Python] how to install pyodbc for maya 2017

[m***@gmail.com]

Hi everybody,

I'm a little bit lost and hope for your help here.

I'm running Maya 2017 update 5 and an microsoft sql server.

I want to use pyodbc in maya to read and write data into our database but i can't get pyodbc to work in maya. if i use an external python shell it works but not in maya. I always get dll missing error. I checked the dependencies and copied the missing msvcr90.dll to the python site-packages which led to another error:

ImportError: DLL load failed: %1 is not a valid Win32 application

can anyone tell me how to get pyodbc working in maya.

thanks in advance

[Justin Israel]

I'm not a Windows user but I imagine that you would have to compile it
against Microsoft Visual Studio 2012 (?) to match the Maya 2017 compiled
version.

Post by m***@gmail.com
Hi everybody,
I'm a little bit lost and hope for your help here.
I'm running Maya 2017 update 5 and an microsoft sql server.
I want to use pyodbc in maya to read and write data into our database but
i can't get pyodbc to work in maya. if i use an external python shell it
works but not in maya. I always get dll missing error. I checked the
dependencies and copied the missing msvcr90.dll to the python site-packages
ImportError: DLL load failed: %1 is not a valid Win32 application
can anyone tell me how to get pyodbc working in maya.
thanks in advance
--
You received this message because you are subscribed to the Google Groups
"Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send an
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/6f79dfcd-9fc9-4065-b549-f86026c6ef9d%40googlegroups.com
.
For more options, visit https://groups.google.com/d/optout.

[MW]

oh my! I had hoped that I can get away without doing any compiling because
I'm a total noob in this topic. maybe anyone on this forum is using a
module in maya to access microsoft sql server (pymssql, pyodbc or something
different). any help would be greatly appreciated!

Post by Justin Israel
I'm not a Windows user but I imagine that you would have to compile it
against Microsoft Visual Studio 2012 (?) to match the Maya 2017 compiled
version.

Post by m***@gmail.com
Hi everybody,
I'm a little bit lost and hope for your help here.
I'm running Maya 2017 update 5 and an microsoft sql server.
I want to use pyodbc in maya to read and write data into our database but
i can't get pyodbc to work in maya. if i use an external python shell it
works but not in maya. I always get dll missing error. I checked the
dependencies and copied the missing msvcr90.dll to the python site-packages
ImportError: DLL load failed: %1 is not a valid Win32 application
can anyone tell me how to get pyodbc working in maya.
thanks in advance
--
You received this message because you are subscribed to the Google Groups
"Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send an
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/6f79dfcd-9fc9-4065-b549-f86026c6ef9d%40googlegroups.com
.
For more options, visit https://groups.google.com/d/optout.

[David Shaw]

You could try a pure python implementation called pymysql (
https://pypi.org/project/PyMySQL/)
It does have some dependencies: crytography, enum, six, and wheel (which
should come doe with the pip install.

I haven't used it yet (still sorting other parts of the pipeline), but
looked into something I could run in Maya and 3DSMax so i didnt have to
compile things multiple times.

Cheers,
Dave

Post by MW
oh my! I had hoped that I can get away without doing any compiling because
I'm a total noob in this topic. maybe anyone on this forum is using a
module in maya to access microsoft sql server (pymssql, pyodbc or something
different). any help would be greatly appreciated!

Post by Justin Israel
I'm not a Windows user but I imagine that you would have to compile it
against Microsoft Visual Studio 2012 (?) to match the Maya 2017 compiled
version.

Post by m***@gmail.com
Hi everybody,
I'm a little bit lost and hope for your help here.
I'm running Maya 2017 update 5 and an microsoft sql server.
I want to use pyodbc in maya to read and write data into our database
but i can't get pyodbc to work in maya. if i use an external python shell
it works but not in maya. I always get dll missing error. I checked the
dependencies and copied the missing msvcr90.dll to the python site-packages
ImportError: DLL load failed: %1 is not a valid Win32 application
can anyone tell me how to get pyodbc working in maya.
thanks in advance
--
You received this message because you are subscribed to the Google
Groups "Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/6f79dfcd-9fc9-4065-b549-f86026c6ef9d%40googlegroups.com
.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups
"Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send an
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%40googlegroups.com
<https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%40googlegroups.com?utm_medium=email&utm_source=footer>
.
For more options, visit https://groups.google.com/d/optout.

[MW]

thanks. I'll take a look.

Post by David Shaw
You could try a pure python implementation called pymysql (
https://pypi.org/project/PyMySQL/)
It does have some dependencies: crytography, enum, six, and wheel (which
should come doe with the pip install.
I haven't used it yet (still sorting other parts of the pipeline), but
looked into something I could run in Maya and 3DSMax so i didnt have to
compile things multiple times.
Cheers,
Dave

Post by MW
oh my! I had hoped that I can get away without doing any compiling
because I'm a total noob in this topic. maybe anyone on this forum is using
a module in maya to access microsoft sql server (pymssql, pyodbc or
something different). any help would be greatly appreciated!

Post by Justin Israel
I'm not a Windows user but I imagine that you would have to compile it
against Microsoft Visual Studio 2012 (?) to match the Maya 2017 compiled
version.

Post by m***@gmail.com
Hi everybody,
I'm a little bit lost and hope for your help here.
I'm running Maya 2017 update 5 and an microsoft sql server.
I want to use pyodbc in maya to read and write data into our database
but i can't get pyodbc to work in maya. if i use an external python shell
it works but not in maya. I always get dll missing error. I checked the
dependencies and copied the missing msvcr90.dll to the python site-packages
ImportError: DLL load failed: %1 is not a valid Win32 application
can anyone tell me how to get pyodbc working in maya.
thanks in advance
--
You received this message because you are subscribed to the Google
Groups "Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/6f79dfcd-9fc9-4065-b549-f86026c6ef9d%40googlegroups.com
.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups
"Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send an
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%40googlegroups.com
<https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%40googlegroups.com?utm_medium=email&utm_source=footer>
.
For more options, visit https://groups.google.com/d/optout.

[Robert White]

I think he's looking for a library to specifically access MS-SQL not MySQL.
Sadly I couldn't find any pure python implementations. So you'll probably
just need to compile your own version.

Post by David Shaw
You could try a pure python implementation called pymysql (
https://pypi.org/project/PyMySQL/)
It does have some dependencies: crytography, enum, six, and wheel (which
should come doe with the pip install.
I haven't used it yet (still sorting other parts of the pipeline), but
looked into something I could run in Maya and 3DSMax so i didnt have to
compile things multiple times.
Cheers,
Dave

Post by MW
oh my! I had hoped that I can get away without doing any compiling
because I'm a total noob in this topic. maybe anyone on this forum is using
a module in maya to access microsoft sql server (pymssql, pyodbc or
something different). any help would be greatly appreciated!

Post by Justin Israel
I'm not a Windows user but I imagine that you would have to compile it
against Microsoft Visual Studio 2012 (?) to match the Maya 2017 compiled
version.

Post by m***@gmail.com
Hi everybody,
I'm a little bit lost and hope for your help here.
I'm running Maya 2017 update 5 and an microsoft sql server.
I want to use pyodbc in maya to read and write data into our database
but i can't get pyodbc to work in maya. if i use an external python shell
it works but not in maya. I always get dll missing error. I checked the
dependencies and copied the missing msvcr90.dll to the python site-packages
ImportError: DLL load failed: %1 is not a valid Win32 application
can anyone tell me how to get pyodbc working in maya.
thanks in advance
--
You received this message because you are subscribed to the Google
Groups "Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/6f79dfcd-9fc9-4065-b549-f86026c6ef9d%40googlegroups.com
.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups
"Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send an
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%40googlegroups.com
<https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%40googlegroups.com?utm_medium=email&utm_source=footer>
.
For more options, visit https://groups.google.com/d/optout.

[Justin Israel]

Is this a possible pure python mssql options?
https://github.com/denisenkom/pytds

It was just a quick search, so I am not sure.

Post by Robert White
I think he's looking for a library to specifically access MS-SQL not MySQL.
Sadly I couldn't find any pure python implementations. So you'll probably
just need to compile your own version.

Post by David Shaw
You could try a pure python implementation called pymysql (
https://pypi.org/project/PyMySQL/)
It does have some dependencies: crytography, enum, six, and wheel (which
should come doe with the pip install.
I haven't used it yet (still sorting other parts of the pipeline), but
looked into something I could run in Maya and 3DSMax so i didnt have to
compile things multiple times.
Cheers,
Dave

Post by MW
oh my! I had hoped that I can get away without doing any compiling
because I'm a total noob in this topic. maybe anyone on this forum is using
a module in maya to access microsoft sql server (pymssql, pyodbc or
something different). any help would be greatly appreciated!

Post by Justin Israel
I'm not a Windows user but I imagine that you would have to compile it
against Microsoft Visual Studio 2012 (?) to match the Maya 2017 compiled
version.

Post by m***@gmail.com
Hi everybody,
I'm a little bit lost and hope for your help here.
I'm running Maya 2017 update 5 and an microsoft sql server.
I want to use pyodbc in maya to read and write data into our database
but i can't get pyodbc to work in maya. if i use an external python shell
it works but not in maya. I always get dll missing error. I checked the
dependencies and copied the missing msvcr90.dll to the python site-packages
ImportError: DLL load failed: %1 is not a valid Win32 application
can anyone tell me how to get pyodbc working in maya.
thanks in advance
--
You received this message because you are subscribed to the Google
Groups "Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/6f79dfcd-9fc9-4065-b549-f86026c6ef9d%40googlegroups.com
.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google
Groups "Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%40googlegroups.com
<https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%40googlegroups.com?utm_medium=email&utm_source=footer>
.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups
"Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send an
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/9cd4bd83-62bf-4879-b82c-35a558f15b72%40googlegroups.com
<https://groups.google.com/d/msgid/python_inside_maya/9cd4bd83-62bf-4879-b82c-35a558f15b72%40googlegroups.com?utm_medium=email&utm_source=footer>
.
For more options, visit https://groups.google.com/d/optout.

[MW]

thanks for the suggestion. Yes, I need a library to access MS-SQL not
MySQL.

pytds can be imported in maya with no problem but I can't get a connection
to the SQL server and currently I don't know why. I think I have to go the
bumpy compile pyodbc against maya road.

Post by Justin Israel
Is this a possible pure python mssql options?
https://github.com/denisenkom/pytds
It was just a quick search, so I am not sure.

Post by Robert White
I think he's looking for a library to specifically access MS-SQL not MySQL.
Sadly I couldn't find any pure python implementations. So you'll probably
just need to compile your own version.

Post by David Shaw
You could try a pure python implementation called pymysql (
https://pypi.org/project/PyMySQL/)
It does have some dependencies: crytography, enum, six, and wheel (which
should come doe with the pip install.
I haven't used it yet (still sorting other parts of the pipeline), but
looked into something I could run in Maya and 3DSMax so i didnt have to
compile things multiple times.
Cheers,
Dave

Post by MW
oh my! I had hoped that I can get away without doing any compiling
because I'm a total noob in this topic. maybe anyone on this forum is using
a module in maya to access microsoft sql server (pymssql, pyodbc or
something different). any help would be greatly appreciated!

Post by Justin Israel
I'm not a Windows user but I imagine that you would have to compile it
against Microsoft Visual Studio 2012 (?) to match the Maya 2017 compiled
version.

Post by m***@gmail.com
Hi everybody,
I'm a little bit lost and hope for your help here.
I'm running Maya 2017 update 5 and an microsoft sql server.
I want to use pyodbc in maya to read and write data into our database
but i can't get pyodbc to work in maya. if i use an external python shell
it works but not in maya. I always get dll missing error. I checked the
dependencies and copied the missing msvcr90.dll to the python site-packages
ImportError: DLL load failed: %1 is not a valid Win32 application
can anyone tell me how to get pyodbc working in maya.
thanks in advance
--
You received this message because you are subscribed to the Google
Groups "Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it,
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/6f79dfcd-9fc9-4065-b549-f86026c6ef9d%40googlegroups.com
.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google
Groups "Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%40googlegroups.com
<https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%40googlegroups.com?utm_medium=email&utm_source=footer>
.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups
"Python Programming for Autodesk Maya" group.
To unsubscribe from this group and stop receiving emails from it, send an
To view this discussion on the web visit
https://groups.google.com/d/msgid/python_inside_maya/9cd4bd83-62bf-4879-b82c-35a558f15b72%40googlegroups.com
<https://groups.google.com/d/msgid/python_inside_maya/9cd4bd83-62bf-4879-b82c-35a558f15b72%40googlegroups.com?utm_medium=email&utm_source=footer>
.
For more options, visit https://groups.google.com/d/optout.