Hi,
I have successfully installed DBD::Sybase and FreeTDS
for my Perl program on Linux.
I also ran the tsql diagnostic routine and at least it
connects to the DB.
So I assume FreeTDS is ok. (I think I got the
freetds-0.61 directory.)
It is also able to find the Sybase.pm module. Cause
that error was sorted out.
At the top of the program we have
#!/usr/bin/perl -w
use DBI;
use DBD::Sybase;
# code...
Now when I try to connect to the DB thru the
connection string it fails
# *** Error Message ***
[EMAIL PROTECTED] perl]$ perl abc.pl
DBI->connect(database:server:portnumber) failed: at
abc.pl line 69
Database connection not made: at abc.pl line 69.
My connection string is as follows. I have tried many
other permutations
but it won't connect.
$SQLSERVER = "hawk"; # hawk is the SQL server, (also
hostname right?)
$SQLUSER = "merit"; # junk username
$SQLPASS = "salem"; # junk pwd
Was told 1433 is the default port number by DBA.
# falcon is the database I want to connect to.
my $dbh =
DBI->connect("DBI:Sybase:falcon:$SQLSERVER:1433",$SQLUSER,$SQLPASS)
|| die ("Database connection not made: $DBI::errstr");
Also tried without port number,
my $dbh =
DBI->connect("DBI:Sybase:falcon:$SQLSERVER",$SQLUSER,$SQLPASS)
|| die ("Database connection not made: $DBI::errstr");
Also tried single quotes, changed case. Tried
database=falcon:hostname=$SQLSERVER
This whole thing wouldn't be a problem if it were
MySQL, it just works fine there...
Please help.
Sincerely,
vk
__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html
