Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Python connect to Sybase IQ
#1
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
Reply
#2
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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  connect sql by python using txt. file dawid294 2 382 Jan-12-2024, 08:54 PM
Last Post: deanhystad
  How to Connect to PostgreSQL Through Jump Server and SSH Tunnel using Python? nishans 1 847 Jan-02-2024, 10:37 AM
Last Post: khanzain
  python connect to mssql wailoonho 7 1,400 Dec-07-2023, 02:06 AM
Last Post: wailoonho
  Using Python to connect to an XML ? jehoshua 12 1,843 Jul-11-2023, 12:34 AM
Last Post: jehoshua
  Trying to make a bot to connect on discord with Selenium Python johnsmith43 2 42,089 Mar-21-2022, 02:56 PM
Last Post: Cloudytechnical
  How to connect Mysql databse with python and VSCode IDE madhusoodhananER 1 8,656 Oct-31-2019, 10:15 AM
Last Post: Larz60+
  Connect a Teradata DB to Python OscarBoots 10 8,750 Jan-31-2019, 10:23 PM
Last Post: OscarBoots
  accessing Sybase (ASE and/or Anywhere) via ODBC... on Linux zatlas1 0 2,858 Jan-31-2019, 06:48 PM
Last Post: zatlas1
  Unable to use sqlanydb to execute Sybase IQ Stored Procedure FORTITUDE 4 3,739 Sep-15-2018, 05:03 PM
Last Post: FORTITUDE
  How to connect Atom and Python? Jack_Sparrow 1 3,714 May-01-2018, 10:53 AM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020