Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Which module should be use for IQ database connection ?

by perlCrazy (Monk)
on Nov 02, 2010 at 17:18 UTC ( [id://869051]=perlquestion: print w/replies, xml ) Need Help??

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

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
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://869051]
Approved by marto
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2024-03-29 06:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found