PDA

View Full Version : DBI - Sybase Connectivity - urgent please


ramshree
03-17-03, 11:00
Hi ,

Machine : Windows 2000 advanced server, Perl 5.8, Sybase 12.5

I am trying to connect to my Sybase Server using DBI. Using following script:

#!d:\perl

use DBI; # Load the DBI module

my ($DBserver, $DBdatabase, $DBuser, $DBpassword) = ('SYBPR','master','test','test123');

my $sdbh = DBI->connect("DBI:Sybase:server=$DBserver;database=$DBdatabase",$DBuser,$DBpassword)
or die "Can't connect to Sybase database: $DBI::errstr\n";

exit;

GETTING following output :

install_driver(Sybase) failed: Can't locate DBD/Sybase.pm in @INC (@INC contains
: D:/Perl/lib D:/Perl/site/lib .) at (eval 1) line 3.
Perhaps the DBD::Sybase perl module hasn't been fully installed,
or perhaps the capitalisation of 'Sybase' isn't right.
Available drivers: ExampleP, ODBC, Proxy, XBase, mysqlPP.
at sybconnect.pl line 7

I search for Sybase.pm , no luck in my perl directory.

I installed DBI through Perl Package Mamager.

Please help.

Thank you,
Ram.

Bernd Dulfer
03-18-03, 08:42
You have to install DBD::Sybase.

Normally you could get it from activestate and install it with ppm.

But it seems, they haven't built it yet for windows.

You have to contact activestate somehow and ask them to provide DBD::Sybase for Perl 5.8.

As I don't use Perl on windows I can't help you further.