http://www.perlmonks.org?node_id=869051

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 (Pope) on Nov 02, 2010 at 18:05 UTC
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.