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

2018-09-12 Thread 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

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

2018-09-12 Thread 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 pytho

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

2018-09-12 Thread 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 pyt

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

2018-09-12 Thread 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 wit

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

2018-09-12 Thread 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

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

2018-09-12 Thread 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. Septem

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

2018-09-12 Thread 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

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

2018-09-12 Thread 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.