I have installed the latest Perl from Activestate and
(Personal) Sybase ASE 12.5 on WindowsXP, as well as the
Sybase Client files and .dlls.
On another part of the system we've managed to get Java
(1.3.1) to connect and talk to Sybase, it seems the Perl
->Sybase connection is proving more tricky than expected.
I've run ppm and installed both DBI and DBD::Sybase for
Perl and used this code to connect :
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
use DBI;
use DBD::Sybase;
my $host = 'localhost';
my $db = 'SYBSRV01';
my $db_username = 'dev';
my $db_password = 'dev';
my $dsn = "dbi:Sybase:server=SYBSRV01";
print "Before connect\n";
$dbh = undef;
$dbh = DBI->connect($dsn, $db_username, $db_password);
print "Please print me, go on - be nice\n";
# it never gets to this point
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Now - the Perl actually connects to Sybase, as I can
see the connection using sp_who on Sybase - and as
you would expect its "AWAITING COMMAND". But control
is never passed back to Perl as no dbh (database
handle) is returned, and the programs hangs at that
point.
I'm completely stumped as to why this might be, I've
turned off (and even uninstalled ZoneAlarm in case
there was any port protection) but no joy.
Has anyone had this problem and solved it or could
suggest anything I might do to further investigate
this issue ?
if so I'd be very grateful
Thanks,
[EMAIL PROTECTED]
____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
