FreeTDS Development Group

["James liu" <liuping.james AT gmail.com>]

FreeBSD 6  php5.21
mssql 2k(with sp4) in winxp

phpinfo show mssql is ok (in FreeBSD6)

i use shell "export TDSVER=7.0 tsql -H...." , it can work.

i use another pc(winxp+php) connect is ok.

i use php
<?php
       putenv("/usr/local/freetds/etc/freetds.conf");
       $dbhost = "192.168.7.12";
       $dbname = "db";
       $dbpass = "123123";
       $dbuname = "t";

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

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

?>

when php testSqlServer.php,,,it show me
"Unable to connect server: 192.168.7.12"

freetds.conf(something modified):
[MyServer2K]
       host = 192.168.7.12
       port = 1433
       tds version = 7.0



anyone know how to fix it?



--
regards
jl