DBD Sybase Connection Check

#!/usr/bin/perl #require "dbdsybase.pl"; BEGIN { $ENV{'SYBASE'} = '/usr/local/freetds'; $ENV{'LD_LIBRARY_PATH'} = '/usr/local/freetds/lib/:/lib/:/lib/tls/'; #$ENV{'USER'} = 'root'; } use CGI; use CGI::Carp; use DBI; my $cgi = new CGI(); print $cgi->header(); my $cgi = new CGI(); my $path='/opt/ash/netcool'; my $hostname="192.168.2.95"; my $portno="4100"; my $database_name="NCOMS"; my $db_username="root"; my $db_password="access"; print < DBD Sybase Connection Check

EOF foreach (sort keys %ENV) { if (($_ eq 'SYBASE')||($_ eq 'LD_LIBRARY_PATH')||($_ eq 'USER')) { print "$_ : $ENV{$_}
"; } } $ldd1=`ldd /usr/local/freetds/lib/Sybase.so`; $ldd2=`ldd /usr/local/freetds/lib/libct.so.4`; print "

ldd of Sybase.so:

$ldd1

ldd of libct.so.4:

$ldd2
"; #print "\nSyabse:$ENV{'SYBASE'}
LD_LIBRARY_PATH:$ENV{'LD_LIBRARY_PATH'}
"; print "

----->$dbh<-----

"; my $dbh = DBI->connect("dbi:Sybase:host=$hostname;port=$portno;server=$database_name;",$db_username,$db_password) || warn "Database Connection not made: $DBI::errstr"; #my $dbh = &datahandle(); print "

$dbh

"; print < EOF ##

##

LD_LIBRARY_PATH : /usr/local/freetds/lib/:/lib/:/lib/tls/
SYBASE : /usr/local/freetds
ldd of Sybase.so:
libct.so.4 => /usr/local/freetds/lib/libct.so.4 (0x00e92000) libdl.so.2 => /lib/libdl.so.2 (0x00fae000) libm.so.6 => /lib/tls/libm.so.6 (0x00402000) libc.so.6 => /lib/tls/libc.so.6 (0x00604000) librt.so.1 => /lib/tls/librt.so.1 (0x00a13000) libpthread.so.0 => /lib/tls/libpthread.so.0 (0x008c6000) /lib/ld-linux.so.2 (0x0093f000)
ldd of libct.so.4:
librt.so.1 => /lib/tls/librt.so.1 (0x00a8c000) libpthread.so.0 => /lib/tls/libpthread.so.0 (0x009be000) libc.so.6 => /lib/tls/libc.so.6 (0x00111000) /lib/ld-linux.so.2 (0x0093f000)
**********-----><-----**********

ldd of Sybase.so:

ldd of libct.so.4:

**********----->$dbh<-----**********

**********$dbh**********

----->$dbh<-----

$dbh