Which module should be use for IQ database connection ?

perlCrazy has asked for the wisdom of the Perl Monks concerning the following question:

DBD::SQLAnywhere or DBD::ODBC.
any pros or cons with above mentioned modules. r Thanks
Comment on Which module should be use for IQ database connection ?

Replies are listed 'Best First'.
Re: Which module should be use for IQ database connection ? by Corion (Patriarch) on Nov 02, 2010 at 18:05 UTC
I use DBD::ODBC to connect to Sybase IQ from Windows. I'm not aware of any drawbacks, and it Just Works. I haven't compared it against DBD::Sybase or DBD::SQLAnywhere.	[reply]
Re: Which module should be use for IQ database connection ? by runrig (Abbot) on Mar 02, 2017 at 21:58 UTC
Update: The below issue has be resolved by recompiling DBD::Oracle against a later version of client libraries (11.2.0.4 instead of 11.2.0). The problem library was libclntsh in the Oracle client library which gets used at runtime by DBD::SQLAnywhere. From unix (Solaris), I've been using DBD::Sybase. When we migrated to linux, we would occasionally get a 'statement interrupted by user' (with no user involved). The DBA said to use DBD::SQLAnywhere, so trying that, it seems to work, but haven't done any extensive testing yet, because there's another problem. Whenever there's an Oracle database handle already connected, the connect() to SQLAnywhere hangs, and eventually exits (w/SEGV), with no error message. Though if you connect to IQ/SQLAnywhere before Oracle, then it does seem to work.	[reply]

Back to Seekers of Perl Wisdom