Date: Wed, 28 Mar 2007 11:15:50 +0800 From: "James liu" <liuping.james@gmail.com> To: freebsd-questions@freebsd.org Subject: question about ports: php5-extensions Message-ID: <5d5204510703272015u3eec1dc9o2115171b0d891fab@mail.gmail.com>
index | next in thread | raw e-mail
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
help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5d5204510703272015u3eec1dc9o2115171b0d891fab>