FreeBSD 3.2 + Apache 1.3.9 + PHP 3.0 + FreeTDS 4.7 + MS SQL 6.5 connection problem.

Alexander Cherevko aliv at is.kiev.ua
Wed Nov 10 09:27:14 EST 1999


Hello.

There is a connection problem. I tried to connect with SQSH 1.7 - worked 
fine (and if -I/usr/local/freetds/interfaces specified - works too).
Connecting with PHP 3.0 (compiled --with-apache) failed.

---------------------------------------
Script:
---------------------------------------
<?php
        $cnn = sybase_connect("ac", "sa", "");
        $lnk = sybase_select_db("ac", $cnn);
        $resultset = sybase_query("select * from syscolumns", $lnk);
        $results = sybase_fetch_array($resultset);
        for($i=0;$i<count(results);$i++) echo "$results[$i] ";
        sybase_close($cnn);
?>
---------------------------------------
Apache's log:
---------------------------------------
connect: Can't assign requested address
DB-Library: Login incorrect.
---------------------------------------
/usr/local/freetds/interfaces:
---------------------------------------
ac                                      
        query tcp ether 10.0.1.117 1433 
        master tcp ether 10.0.1.117 1433
---------------------------------------
php3.ini
---------------------------------------
[Sybase]
sybase.allow_persistent =   On
sybase.max_persistent   =   -1
sybase.max_links        =   -1
sybase.interface_file   =   "/usr/local/freetds/interfaces"
sybase.min_error_severity   =   10
sybase.min_message_severity =   10
sybase.compatability_mode   = Off
---------------------------------------
MS SQL configuration
---------------------------------------
TCP/IP = 10.0.1.117
port   = 1433
login  = sa
password =


Can you help me?

Thanks.



More information about the FreeTDS mailing list