Python Forum
Unable to use sqlanydb to execute Sybase IQ Stored Procedure
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Unable to use sqlanydb to execute Sybase IQ Stored Procedure
#1
Hi All,

I am using library sqlanydb to access Sybase IQ database.

It was running fine until it hits some statement that will insert into a temp table (e.g. #temp). Is it related to some connection setup?

If there is no workaround on this, is there any better API to hook up Sybase IQ database?

Thanks,

Allen
Reply
#2
There is another package that looks promising (I haven't used it, but you might want to try). It supports sybase and several other DBM's.
see SQLobject: http://sqlobject.org/
Reply
#3
Thank you Larz60+ but it doesn't provide connectivity with Sybase IQ.
Reply
#4
Didn't notice the IQ before. What is the difference between IQ and standard Sybase?
Reply
#5
Standard Sybase is the legacy ASE (Adaptive Server Enterprise) while IQ is the Index based database which is has better performance and more advance.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  python script is hanging while calling a procedure in database prasanthi417 4 442 Jan-17-2024, 02:33 PM
Last Post: deanhystad
  python call stored procedure mg24 2 1,025 Oct-18-2022, 02:19 AM
Last Post: mg24
  python call stored procedure with two parameter mg24 4 1,400 Sep-27-2022, 05:02 AM
Last Post: deanhystad
  Unable to execute input(). jahuja73 5 4,371 Feb-18-2021, 07:41 AM
Last Post: bowlofred
  capture print statement written in Stored Procedure in SQL Server brijeshkumar_77 0 2,515 Feb-18-2020, 03:22 AM
Last Post: brijeshkumar_77
  Execute SQL Server Stored Procedure brijeshkumar_77 0 2,978 Feb-18-2020, 02:59 AM
Last Post: brijeshkumar_77
  Unable to execute the for loop harold 1 1,698 Sep-23-2019, 12:27 PM
Last Post: buran
  What do you think of this procedure to create a path to a folder atlass218 10 6,366 Sep-06-2019, 07:53 AM
Last Post: atlass218
  How to return value from a stored procedure of a MySQL database? UtiliseIT 0 2,297 Jul-22-2019, 10:14 AM
Last Post: UtiliseIT
  Add a stored procedure with variable using MySQL Connector UtiliseIT 0 2,266 May-04-2019, 12:46 PM
Last Post: UtiliseIT

Forum Jump:

User Panel Messages

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