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