I admit my newness first off. I am trying to connect to two databases. One is local
which is a mySQL database, and the other is a remote (same subnet) Sybase database.
Does anyone have an idiot's guide - version of how I install the Sybase and mySql
drivers as the solution to the error message here:
install_driver(Sybase) failed: Can't locate loadable object for module DBD::Sybase in
@INC (@INC contains: /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0
/usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl .) at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a module that DBD::Sybase requires hasn't been fully installed
at dac_src.pl line 54
I also have some perl code written to connect to the Sybase database,,,, not sure if
that's right, but here it is:
#----------------------------------------------------------------------
# SQL DSN setup, and login to DAC6000
#----------------------------------------------------------------------
$dsn = "DBI:SYBASE:database=acc4000;host=dac6000";
$user="acc4000";
$table = "source";
$dbh = DBI->connect($dsn, $user);
#----------------------------------------------------------------------
# SQL select statement
#----------------------------------------------------------------------
my $sth = $dbh->prepare("SELECT * FROM $table");
