2

I am using pypyodbc from within a specialized called Motionbuilder, and recently I've been getting this strange error:

pypyodbc.Error: (u'HY090', u'[HY090] [Microsoft][ODBC Driver Manager] Invalid string or buffer length')

It doesn't happen every time, only sometimes. Any ideas?

Nateon Ajello
  • 21
  • 2
  • What ODBC driver are you using? Is it a special driver for MotionBuilder data, or is it for some other data source that you are trying to access from within MotionBuilder? – Gord Thompson Apr 30 '16 at 17:23
  • I'm using ODBC Driver 11 for SQL Server, very standard. Our Database is being accessed through a Python implementation within Motionbuilder. – Nateon Ajello May 02 '16 at 19:33
  • Can I look at the code raising this error? Sound like there is a mal formed query here... – patito May 05 '16 at 11:27
  • 1
    Definitely not a malformed Query. Works in any other SQL application, even in other versions of Motionbuilder. I think it has more to do with our ODBC driver and whatever program Python is running through. We also have the problem with multiple different queries – Nateon Ajello Jul 20 '16 at 21:45
  • hi, @NateonAjello Did you resolved the issue? thanks. – mrtpk Jul 26 '17 at 08:34
  • We ended up going back to PYODBC, which doesn't ever seem to have a problem. We also had to recompile it against VS 2012 to use with the newer Motionbuilder and Maya. – Nateon Ajello Jul 27 '17 at 21:30

0 Answers0