Can someone please look into my below code and error and suggest what exactly is the error here and How should I move forward to get it right. Thanks in advance. 
#!/u001/dev/edw/common/ul/bin/perl
#Batch history: Developed by Saurav Rout

use strict;
use warnings;

use DBI;
use DBD::ODBC;

my $host = "db.myhost.com";  # = "localhost", the server your are on.
my $db = "u210502";       # your username (= login name  = account nam
+e )
my $user = $db;           # your Database name is the same as your acc
my $pwd = 'xxxxxx';             # Your account password



# connect to the database.

print(__PACKAGE__ . ':' . __LINE__ . ":Connecting...\n");
$dbh = DBI->connect( "DBI:ODBC:$host", $user, $pwd)
        or die "Connecting : $DBI::errstr\n ";
print(__PACKAGE__ . ':' . __LINE__ . ":Connected.\n");

$sql = "SELECT * FROM D_EIW_W_DEVWORK_1.daily_batch_report";


# executing the SQL statement.


$sth = $dbh->prepare($sql) or die "preparing: ",$dbh->errstr;
$sth->execute or die "executing: ", $dbh->errstr;

print "content-type: text/html\n\n";


# one of the functions to retrieve data from the table results
# check perldoc DBI for more methods.


while ($row = $sth->fetchrow_hashref)        
   {
   foreach(sort(keys(%$row)))    
      {
      print("$_:\[$row->{$_}\]\n");
      }
   }

[download]
And the error I am getting is: 
[edwdev2:u210502] /u001/dev/edw/common/ul/cgi-bin/eiw $ perl batch_his
+t
Can't load '/u001/dev/edw/common/ul/perl5/lib/site_perl/5.8.0/aix-64al
+l/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC:    0509-022 Cannot loa
+d module /u001/dev/edw/common/ul/perl5/lib/site_perl/5.8.0/aix-64all/
+auto/DBD/ODBC/ODBC.so.
        0509-150   Dependent module libodbc.a(odbc.so) could not be lo
+aded.
        0509-022 Cannot load module libodbc.a(odbc.so).
        0509-026 System error: A file or directory in the path name do
+es not exist.
        0509-022 Cannot load module /u001/dev/edw/common/ul/perl5/lib/
+site_perl/5.8.0/aix-64all/auto/DBD/ODBC/ODBC.so.
        0509-150   Dependent module /u001/dev/edw/common/ul/perl5/lib/
+site_perl/5.8.0/aix-64all/auto/DBD/ODBC/ODBC.so could not be loaded. 
+at /u001/dev/edw/common/ul/perl5/lib/5.8.0/aix-64all/DynaLoader.pm li
+ne 229.
 at batch_hist line 8
Compilation failed in require at batch_hist line 8.
BEGIN failed--compilation aborted at batch_hist line 8.

[download]

In reply to Perl ODBC error by sauravrout

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.