+- 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: Unable to use sqlanydb to execute Sybase IQ Stored Procedure (/thread-12831.html)
Unable to use sqlanydb to execute Sybase IQ Stored Procedure - FORTITUDE - Sep-15-2018
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
RE: Unable to use sqlanydb to execute Sybase IQ Stored Procedure - Larz60+ - Sep-15-2018
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/
RE: Unable to use sqlanydb to execute Sybase IQ Stored Procedure - FORTITUDE - Sep-15-2018
Thank you Larz60+ but it doesn't provide connectivity with Sybase IQ.
RE: Unable to use sqlanydb to execute Sybase IQ Stored Procedure - Larz60+ - Sep-15-2018
Didn't notice the IQ before. What is the difference between IQ and standard Sybase?
RE: Unable to use sqlanydb to execute Sybase IQ Stored Procedure - FORTITUDE - Sep-15-2018
Standard Sybase is the legacy ASE (Adaptive Server Enterprise) while IQ is the Index based database which is has better performance and more advance.