Loading ...
Sorry, an error occurred while loading the content.

DBD problem on HPUX-11

Expand Messages
  • Marshal
    Hi all, My system admin. installed a perl ver. 5.6.1 on HPUX11. I am unable to connect to the database using DBD. The error I get is as follows:
    Message 1 of 1 , Sep 26, 2002
    • 0 Attachment
      Hi all,

      My system admin. installed a perl ver. 5.6.1 on HPUX11.

      I am unable to connect to the database using DBD. The error I get is
      as follows:

      ================== ERROR START ==================================
      Can't
      load '/opt/tools/PERL561HPO11/lib/site_perl/auto/DBD/Oracle/Oracle.sl'
      for module DBD::Oracle: No such file or directory
      at /opt/tools/PERL561HPO11/lib/DynaLoader.pm line 206.
      at ./Mytest.pl line 3
      Compilation failed in require at ./Mytest.pl line 3.
      BEGIN failed--compilation aborted at ./Mytest.pl line 3.
      ================== ERROR END ==================================

      Though the file "Oracle.sl" exisits in the said path, but some how
      it is not being loaded.

      Following is my perl program

      ================= PERL PROG. START =============================
      !/opt/tools/PERL561HPO11/bin/perl -w

      use DBI;
      use DBD::Oracle;

      $dbh = DBI->connect("dbi:Oracle:host=myhost.mydomain.com;sid=mysid",
      user_name, password);

      my $sth = $dbh->prepare('select * from test');
      $sth->execute();
      my $count = 0;
      print "\n";
      while ( my @val = $sth->fetchrow_array())
      {
      print "DB record $val[0], $val[1]\n";
      }
      $sth->finish;
      $dbh->disconnect;
      exit 0
      ================= PERL PROG. END =============================


      Can anyone help?

      Best Regards.
    Your message has been successfully submitted and would be delivered to recipients shortly.