+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Python connect to Sybase IQ (/thread-15499.html)
Python connect to Sybase IQ - FORTITUDE - Jan-19-2019
Hi Team,
I am trying to use sqlanydb Python API to invoke a stored procedure deployed in Sybase IQ. I am calling this stored procedure successfully in any of the DB Tool like DBArtison and DBVisualizer (possibly using JDBC driver). I can always return results.
Unfortunately I am using given sample to execute this stored procedure but getting funny error saying failed to insert into a temp table. This actually happened right after a inner stored procedure call of my stored procedure.
I remember I encountered similar situation using pyodbc before but issue cleared after adding "SET ANSINULL OFF" in the top. I tried here but it doesn't turn out to have the same happy ending.
I tried couple tweaking over past few days 12 hours per day but this i still not working.
Do you have any suggestion?
Thanks.
Fortitude
RE: Python connect to Sybase IQ - micseydel - Jan-24-2019
This sounds very niche, so I'm not sure we'll be able to help. That said, you should generally include your code and full stack trace, both of which have been omitted here.