使用PHP连接MSSQL数据库连接
问题描述:
请尝试连接到不同机器上的mssql数据库。下面是我的代码,但我只是不断得到一个空白页。使用PHP连接MSSQL数据库连接
我不知道这个问题可能是什么。我已经安装了php和mssql驱动程序。
<?php
$uid = "******";
$pwd = "***\$\$****";
$DB = "***********";
$serverName = "192.***.**.***";
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=> $DB, "ReturnDatesAsStrings" => true);
$conn = sqlsrv_connect($serverName, $connectionInfo);
if($conn) {
echo "Connection established.<br />";
}else{
echo "Connection could not be established.<br />";
die(print_r(sqlsrv_errors(), true));
}
?>
答
我建议您使用sqlsrv_errors()
来显示连接错误。
加载php.ini
文件中的PHP驱动程序并重新启动服务器。
extension=php_pdo_sqlsrv_54_ts.dll
extension=php_sqlsrv_54_ts.dll
请看下面的例子:
<?php
$serverName = "serverName\sqlexpress"; //serverName\instanceName
// Since UID and PWD are not specified in the $connectionInfo array,
// The connection will be attempted using Windows Authentication.
$connectionInfo = array("Database"=>"dbName");
$conn = sqlsrv_connect($serverName, $connectionInfo);
if($conn) {
echo "Connection established.<br />";
}else{
echo "Connection could not be established.<br />";
die(print_r(sqlsrv_errors(), true));
}
?>
欲了解更多信息:http://php.net/manual/en/function.sqlsrv-connect.php
检查与此同时使连接:' “数据库”=> “数据库名”, “UID”=> “userName”,“PWD”=>“密码”' – ggupta