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

[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.

Am Mittwoch, 12. September 2018 22:00:59 UTC+2 schrieb 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. 
>
>
> On Thu, Sep 13, 2018, 2:16 AM Robert White  > wrote:
>
>> 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.
>>
>> On Wednesday, September 12, 2018 at 6:27:35 AM UTC-5, flop...@gmail.com 
>> wrote:
>>>
>>> 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
>>>
>>>
>>> On Wed, Sep 12, 2018 at 9:02 PM MW  wrote:
>>>
 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!

 Am Mittwoch, 12. September 2018 12:56:33 UTC+2 schrieb 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. 
>
> On Wed, Sep 12, 2018, 10:50 PM  wrote:
>
>> 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
>>
>> -- 
>> 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 email to python_inside_maya+unsubscr...@googlegroups.com.
>> 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 email to python_inside_maya+unsubscr...@googlegroups.com.
 To view this discussion on the web visit 
 https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%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 
>> email to python_inside_maya+unsubscr...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/python_inside_maya/9cd4bd83-62bf-4879-b82c-35a558f15b72%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 email 
to python_inside_maya+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/python_inside_maya/36482f60-5f33-450a-91a6-4c533c64c75a%40googlegroups.com.
For more options, visit 

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

[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.


On Thu, Sep 13, 2018, 2:16 AM Robert White 
wrote:

> 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.
>
> On Wednesday, September 12, 2018 at 6:27:35 AM UTC-5, flop...@gmail.com
> wrote:
>>
>> 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
>>
>>
>> On Wed, Sep 12, 2018 at 9:02 PM MW  wrote:
>>
>>> 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!
>>>
>>> Am Mittwoch, 12. September 2018 12:56:33 UTC+2 schrieb 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.

 On Wed, Sep 12, 2018, 10:50 PM  wrote:

> 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
>
> --
> 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 email to python_inside_maya+unsubscr...@googlegroups.com.
> 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 email to python_inside_maya+unsubscr...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%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
> email to python_inside_maya+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/python_inside_maya/9cd4bd83-62bf-4879-b82c-35a558f15b72%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 email 
to python_inside_maya+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/python_inside_maya/CAPGFgA32YEKUarEQmBMimCuwB7Uz2a%2Bd5B0JUYPOF70dyDAFrg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

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

[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.

On Wednesday, September 12, 2018 at 6:27:35 AM UTC-5, flop...@gmail.com 
wrote:
>
> 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
>
>
> On Wed, Sep 12, 2018 at 9:02 PM MW > 
> wrote:
>
>> 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!
>>
>> Am Mittwoch, 12. September 2018 12:56:33 UTC+2 schrieb 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. 
>>>
>>> On Wed, Sep 12, 2018, 10:50 PM  wrote:
>>>
 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

 -- 
 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 email to python_inside_maya+unsubscr...@googlegroups.com.
 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 
>> email to python_inside_maya+unsubscr...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%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 email 
to python_inside_maya+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/python_inside_maya/9cd4bd83-62bf-4879-b82c-35a558f15b72%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[MW]

thanks. I'll take a look.

Am Mittwoch, 12. September 2018 13:27:35 UTC+2 schrieb flop...@gmail.com:
>
> 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
>
>
> On Wed, Sep 12, 2018 at 9:02 PM MW > 
> wrote:
>
>> 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!
>>
>> Am Mittwoch, 12. September 2018 12:56:33 UTC+2 schrieb 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. 
>>>
>>> On Wed, Sep 12, 2018, 10:50 PM  wrote:
>>>
 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

 -- 
 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 email to python_inside_maya+unsubscr...@googlegroups.com.
 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 
>> email to python_inside_maya+unsubscr...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%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 email 
to python_inside_maya+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/python_inside_maya/b9ac6689-8878-42ab-9e76-c22735392639%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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


On Wed, Sep 12, 2018 at 9:02 PM MW  wrote:

> 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!
>
> Am Mittwoch, 12. September 2018 12:56:33 UTC+2 schrieb 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.
>>
>> On Wed, Sep 12, 2018, 10:50 PM  wrote:
>>
>>> 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
>>>
>>> --
>>> 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 email to python_inside_maya+unsubscr...@googlegroups.com.
>>> 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
> email to python_inside_maya+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%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 email 
to python_inside_maya+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/python_inside_maya/CAGvmHEdOqD45%2BEvZ4xB5vdHckc_qMoL0c9tVq6eYjqd-ZPzcxA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

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

[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!

Am Mittwoch, 12. September 2018 12:56:33 UTC+2 schrieb 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. 
>
> On Wed, Sep 12, 2018, 10:50 PM > wrote:
>
>> 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
>>
>> -- 
>> 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 
>> email to python_inside_maya+unsubscr...@googlegroups.com .
>> 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 email 
to python_inside_maya+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/python_inside_maya/5d4bca57-77c8-4df2-be14-2a36afad3760%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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.

On Wed, Sep 12, 2018, 10:50 PM  wrote:

> 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
>
> --
> 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
> email to python_inside_maya+unsubscr...@googlegroups.com.
> 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 email 
to python_inside_maya+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/python_inside_maya/CAPGFgA14j%3DYgqDKx4tx9YG5kTqHHnRGRHLo51FFaOaQUyz7cBg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

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

[migewa77]

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

-- 
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 email 
to python_inside_maya+unsubscr...@googlegroups.com.
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.