De PHPhulp kroeg
PHP via PDO connecten met remote MS SQL server
Ik maak gebruik van de onderstaande code / connection string om te verbinden met mijn MS SQL server.
dbnaam, user en ***** heb ik (uiteraard) correct ingevuld.
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
2
3
4
5
6
7
8
9
10
11
12
13
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
$conn = new PDO("sqlsrv:Server=den1.mssql1.gear.host\\SQLEXPRESS;Database=dbnaam", "user", "****");
$conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$sql = "SELECT * FROM gebruikers";
foreach ($conn->query($sql) as $row) {
print_r($row);
}
?>
error_reporting(E_ALL);
ini_set('display_errors', 1);
$conn = new PDO("sqlsrv:Server=den1.mssql1.gear.host\\SQLEXPRESS;Database=dbnaam", "user", "****");
$conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$sql = "SELECT * FROM gebruikers";
foreach ($conn->query($sql) as $row) {
print_r($row);
}
?>
Output:
Fatal error: Invalid handle returned. in C:\home\site\wwwroot\index.php on line 6
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
$serverName = "tcp:******, 1433";
$database = "*******";
$uid = "*******";
$pwd = "********";
$conn = new PDO( "sqlsrv:server=" . $serverName . "; Database = " . $database, $uid, $pwd);
$sql = "SELECT * FROM gebruikers";
foreach ($conn->query($sql) as $row)
{
print_r($row);
}
?>
error_reporting(E_ALL);
ini_set('display_errors', 1);
$serverName = "tcp:******, 1433";
$database = "*******";
$uid = "*******";
$pwd = "********";
$conn = new PDO( "sqlsrv:server=" . $serverName . "; Database = " . $database, $uid, $pwd);
$sql = "SELECT * FROM gebruikers";
foreach ($conn->query($sql) as $row)
{
print_r($row);
}
?>
Gewijzigd op 21/10/2018 10:55:18 door bas hooff