mssql_connect() [function.mssql-connect]: message: 用户 'sa' 登录失败。原因: 未与信任 SQL Server 连接相关联。 (severity 14) in D:\AppServ\www\pnr.php on line 40 提示作用的错误问题出现在上面地方?
$conn=mssql_connect($server,$username,$password) or die("Couldn't connect to SQL Server on $server"); $db=mssql_select_db($database) or die("Couldn't open database $database"); $sql = "SELECT * FROM Sheet1$"; //sql语句 $data = mssql_query($sql); //把查询的值集合在变量$data while($Arr = mssql_fetch_object($data)) //循环初始的集合$Arr { $id=$Arr->ID; echo $id."<br>"; }
//请看代码
$server='192.168.1.168';
$username='sa';
$password='sa';
$database='aa';
$conn=mssql_connect($server,$username,$password)
or die("Couldn't connect to SQL Server on $server");
$db=mssql_select_db($database) or die("Couldn't open database $database");
$sql = "SELECT * FROM Sheet1$"; //sql语句
$data = mssql_query($sql); //把查询的值集合在变量$data
while($Arr = mssql_fetch_object($data)) //循环初始的集合$Arr
{
$id=$Arr->ID;
echo $id."<br>";
}