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

Has anyone attempted to use DBI with Red Brick and had success? Specifically DBD::Informix? Or DBD::ODBC? I am going to be attempting this on a unix machine (HPUX).

I have solved it via Risql (a tool owned by Red Brick), but with this solution I haven't a direct access to the DB. Could anyone help me?

Replies are listed 'Best First'.
Re: Searching a DBI for Red Brick on HPUX
by gellyfish (Monsignor) on Aug 11, 2004 at 12:28 UTC

    I am sure everyone in the Perl community knows what you are trying to do by now, except perhaps for the one person two three four (*) people who voted to keep this node who I assume isn't aren't on any of the mailling lists, usenet groups and other web sites where you have posted this question.

    As I answered you on the London.pm Mail List:

    On Tue, 2004-08-10 at 16:40, Armin Zendron wrote:
    > Has anyone attempted to use DBI with Red Brick and had 
    > success?  Specifically DBD::Informix?
    >   
    > I am going to be attempting this on a unix machine (hpux).
    
    The Red Brick client protocol is different to the Informix IDS one
    despite Informix having bought the database ages ago - I would be highly
    skeptical that it would work, there may  however be a unix ODBC driver
    available in which case you will be able to use DBD::ODBC (if you
    install unixodbc or iODBC or whatever).
    
    /J\
    
    You can find more details about the Red Brick ODBC driver here and there is a Red Brick specific mailling list here where I am sure you will find someone who can answer your question.

    (*) Astonishing - I guess that there must be people who think this *IS* the Perl community.. :-)

    /J\