https://community.sap.com/t5/application-development-and-automation-discussions/python-connect-to-sybase-iq/m-p/756689#M36632 <P> </P> <P>Hi Team,<BR /><BR />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.<BR /><BR />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.<BR /><BR />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.<BR /><BR />I tried couple tweaking over past few days 12 hours per day but this i still not working.<BR /><BR />Do you have any suggestion?<BR /><BR />Thanks.<BR /><BR />Fortitude</P> Tue, 22 Jan 2019 05:45:43 GMT Former Member 2019-01-22T05:45:43Z https://community.sap.com/t5/application-development-and-automation-discussions/python-connect-to-sybase-iq/m-p/756689#M36632 <P> </P> <P>Hi Team,<BR /><BR />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.<BR /><BR />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.<BR /><BR />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.<BR /><BR />I tried couple tweaking over past few days 12 hours per day but this i still not working.<BR /><BR />Do you have any suggestion?<BR /><BR />Thanks.<BR /><BR />Fortitude</P> Tue, 22 Jan 2019 05:45:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/python-connect-to-sybase-iq/m-p/756689#M36632 Former Member 2019-01-22T05:45:43Z