Python Forum

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

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/

Thank you Larz60+ but it doesn't provide connectivity with Sybase IQ.

Didn't notice the IQ before. What is the difference between IQ and standard Sybase?

Standard Sybase is the legacy ASE (Adaptive Server Enterprise) while IQ is the Index based database which is has better performance and more advance.