From owner-freebsd-questions@FreeBSD.ORG  Wed Mar 28 03:43:30 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id A164C16A403
	for <freebsd-questions@freebsd.org>;
	Wed, 28 Mar 2007 03:43:30 +0000 (UTC)
	(envelope-from liuping.james@gmail.com)
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.224])
	by mx1.freebsd.org (Postfix) with ESMTP id 621C513C46A
	for <freebsd-questions@freebsd.org>;
	Wed, 28 Mar 2007 03:43:30 +0000 (UTC)
	(envelope-from liuping.james@gmail.com)
Received: by wx-out-0506.google.com with SMTP id s18so2488124wxc
	for <freebsd-questions@freebsd.org>;
	Tue, 27 Mar 2007 20:43:29 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	b=DFRAaHk9koYYejSNKJKwLlnzwUZIYTQxUSotY+zpNtVCzg3DATAA6AQEjWE2qqorra69OUJV3T+GJ1cBCPm8Q6O9S/FqGNTVKfR7anJ1AyuGv+NWcCk+0BV6i3+fZR/wfEDcEpuESAE/mWiJEIlZvZaNsgMITVSPa7IG5vocmVE=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=j0h4po5p6ziiYUyhXBBXmt6nZcQtt34IJFFgOz4kXibfHKY/HUKpoA4AKsHmVZOvP/sxFZDBHCFiWZaZ4CH5T4BtSGESAF/HaB85sF4TgJVOEC6JQ15xFSq7kSPJn2hqjL9c+RC9xKE5GEeS1LY0Zf+ADTu9UCn78B/2ON14csE=
Received: by 10.70.116.14 with SMTP id o14mr796940wxc.1175051750480;
	Tue, 27 Mar 2007 20:15:50 -0700 (PDT)
Received: by 10.70.55.18 with HTTP; Tue, 27 Mar 2007 20:15:50 -0700 (PDT)
Message-ID: <5d5204510703272015u3eec1dc9o2115171b0d891fab@mail.gmail.com>
Date: Wed, 28 Mar 2007 11:15:50 +0800
From: "James liu" <liuping.james@gmail.com>
To: freebsd-questions@freebsd.org
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Subject: question about ports: php5-extensions
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 28 Mar 2007 03:43:30 -0000

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