<?php
$conInfo=array('Database'=>'db_office', 'UID'=>'sa', 'PWD'=>'123456');
$conn=sqlsrv_connect('localhost', $conInfo);
?>
中 $conn=sqlsrv_connect('localhost', $conInfo);提示错误,我之前在phpstudy的端口设置为8080,访问网页都加上了:8080.但是这行代码应该怎样改
是不是你数据库名或者密码用户错误
服务名是对的吗 //serverName\instanceName, portNumber (default is 1433) 这个对一下
<?php
$serverName = "serverName\sqlexpress, 1542"; //serverName\instanceName, portNumber (default is 1433)
$connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
echo "Connection established.
";
}else{
echo "Connection could not be established.
";
die( print_r( sqlsrv_errors(), true));
}
?>
UID Upwd没错吧~
你链接数据库的时候是写的哪个端口,数据库软件默认的是3306看看是不是忘记改掉了
端口没有写,很明显的错误
登录的时候要指明改后的端口