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

i am on solaris 10 using sybase dblib on most of my perl scripts. we are now moving to RHEL 6. Pls note I have no root access, can i get sybase dblib to work on rhel? we have DBI on rhel but no dbd sybase. can i have dbd sybase installed on one of my custom libraries? below is what i have. perl -v This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi
  • Comment on what are my options with perl, sybase dblib?

Replies are listed 'Best First'.
Re: what are my options with perl, sybase dblib?
by FreeBeerReekingMonk (Deacon) on May 29, 2015 at 20:49 UTC

    Hard to say. You can install many things with CPAN in userspace, that is, inside your homedirectory, but you will need internet access for that, or other means to transfer the files to. Just try: "cpan Sybase::DBlib" and see where that gets you... I tested it on my RH installation, and you will need a locally installed SYBASE, or maybe just the configuration file somewhere and point $SYBASE to that before it can build... not sure. Sybase::DBlib on CPAN Perl with Sybase: sybperl or DBI/DBD::Sybase?

    Edit: Here is your solution, with installation instructions and all:
    DBD::Sybase on Linux -- trouble?

    1. get the Sybase libs - available as part of the Sybase ASE free download on the Sybase site.
    2. pretty simple CPAN install
    3. Thank mpeppler

      thanks, so you are saying i can actually get sybase dblib to work on rh ? if so i would like to explore that. my server should have sybase client installed. i dont want to break my head on DBD, its too much trouble, too many dependencies. i tried it for sql server, finally wrote a java api and started calling that from perl, was much easier than getting dbd and dbi to work. i am trying my luck before i take the same route for sybase as well.

        ...was much easier than getting dbd and dbi to work...

        Hi taiq_m, Your ideas are intriguing to me and I wish to subscribe to your newsletter.

        :)

        Although perl is the obvious best option. If you are venturing into java (note the lowercase j). I did some successful coding in Jython. You see, you can grab the jython jar, rename it to zip, and inject/copy all the (either Oracle or DB2) jdbc files into the zip, then rename it back. What you then have is a slightly overweight jython jar, which, without any fuzz, can connect to a database, and runs on Linux/AIX/Windows/Breadtoaster if you have the right java installed. It might work with Sybase too.

        Now if you excuse me, I need to do penance for suggesting something else than perl....