question about ports: php5-extensions

James liu liuping.james at gmail.com
Wed Mar 28 03:43:30 UTC 2007


FB 6,,,,i first setup freetds in /usr/local/freetds
and use its tsql to test connect ms sql server, it is ok.

setup php5-extensions,,and click mssql(option)

i find it use another freetds,,,but not show me error information.  setup is
complete.

i can find mssql support with phpinfo.

so i use
<?php
        $dbhost = "192.168.7.112";
        $dbname = "t";
        $dbpass = "123123";
        $dbuname = "test";

        $con = mssql_connect($dbhost, $dbuname, $dbpass);
        $ret = mssql_select_db($dbname);
        $sql = " select top 10 IdxID as id, Topic as posttopic from ttt
        $result = mssql_query($sql);

        while($row = mssql_fetch_array($result)){
                echo "ID:".$row['id']."name:".$row['posttopic'];
        }

?>

and it show me
Unable to connect: 192.168.7.112

i use winxp and tsql(freetds test tool)to test connection...they all ok.

i read php handbook and google,,,,all show me setup with
-with-mssql=/usr/local/freetds

but php5-extensions seems to do it....(just click checked mssql)

am i right? and how can i fix it ?

anyone know?



-- 
regards
jl


More information about the freebsd-questions mailing list