|
 |
| |
Connection could not be established ยาวมากเลยคับ พอจะทราบไหมครับ ว่าerror เพราะอะไรครับ |
| |
 |
|
|
 |
 |
|
แต่พอผมใช้
Code (PHP)
<?php
$serverName = "serverName\sqlexpress"; //serverName\instanceName
$connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$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));
}
?>
ตัวนี้ขึ้นว่า Connection established
|
 |
 |
 |
 |
| Date :
2018-01-09 14:38:47 |
By :
shiowa |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
8080 ไม่ใช่ port ที่ใช้งานกับ sql server ทำให้ เชื่อมต่อไม่ได้
พอเอาออก ก็จะใช้ค่า port default คือ 1433 ทำให้เชื่อมต่อได้
|
| |
|
|
| |
| Date :
2018-01-09 15:13:12 |
By :
Chaidhanan |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (PHP)
<?php
ini_set('display_errors', 1);
error_reporting(~0);
$serverName = "localhost";
$userName = "sa";
$userPassword = "";
$dbName = "mydatabase";
$connectionInfo = array("Database"=>$dbName, "UID"=>$userName, "PWD"=>$userPassword, "MultipleActiveResultSets"=>true);
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if($conn)
{
echo "Database Connected.";
}
else
{
die( print_r( sqlsrv_errors(), true));
}
sqlsrv_close($conn);
?>
PHP SQL Server Configuration & Connect to Database (sqlsrv)
|
| |
|
|
| |
| Date :
2018-01-09 15:58:20 |
By :
mr.win |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 03
|
