CPAN::Forum
DBD-Sybase - Unable to find server for ASE 15.0 on Linux
| Posted on Sun Jan 1 21:23:56 2006 by akaodin |
| Unable to find server for ASE 15.0 on Linux |
|
Hi,
I have installed DBD::SyBase v1.07 on my RedHat 9 Linux server. I
also installed FreeTDS and am able to easily connect to SQL Server
sitting on a Windows box. My problem is Sybase ASE 15.0. I am able to
connect to my Sybase server known as DJX from the command line. However,
when I try the same using the DBD it consistently tells me that the
server is unavailable. My connect string is:
DBI->connect("dbi:Sybase:server=DJX;database=odin", $usr, $pwd);
I also tried:
$ENV{DSQUERY} = "DJX";
DBI->connect("dbi:Sybase:;database=odin", $usr, $pwd);
I have tried setting the environment in Apache explicitly to locate
$SYBASE. I verify it by looking at the results of
print "<center>SYBASE = $ENV{SYBASE}</center>";
The Apache error log gives the msgs:
src/tds/login.c: tds_connect: 10.0.0.164:5000: Connection refused
DBI connect('server=DJX;database=odin','odin',...) failed: OpenClient
message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (41)
Server DJX, database
Message String: Server is unavailable or does not exist.
My $SYBASE/interfaces is
DJX
master tcp eth0 djx 5000
query tcp eth0 djx 5000
djx is correctly listed in my /etc/hosts and I have even tried replacing it w/ the proper IP
address.
A little more info. The Perl:DBI works well for the following dbs: DB2,
Oracle, MySQL, PostgreSQL, SQLite and, as mentioned earlier, SQL Server.
I have been struggling w/ this problem constantly for the past several
weeks and am about ready to give up. Pls - any suggestions. Thx in advance
|
| Write a response |
(5)
]