ตอนที่ 6 : SQL Azure รู้จักกับ Connection String สิทธิ์การใช้งาน SQL Database

Server=tcp:bc6hela9fr.database.windows.net,1433;Database=thaicreate-db;User ID=thaicreate-user@bc6hela9fr;Password={your_password_here};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;

Driver={SQL Server Native Client 10.0};Server=tcp:bc6hela9fr.database.windows.net,1433;Database=thaicreate-db;Uid=thaicreate-user@bc6hela9fr;Pwd={your_password_here};Encrypt=yes;Connection Timeout=30;

Server: bc6hela9fr.database.windows.net,1433 
SQL Database: thaicreate-db
User Name: thaicreate-user
Password={your_password_here}

try {
	$conn = new PDO ( "sqlsrv:server = tcp:bc6hela9fr.database.windows.net,1433; Database = thaicreate-db", "thaicreate-user", "{your_password_here}");
	$conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
}
	catch ( PDOException $e ) {
	print( "Error connecting to SQL Server." );
	die(print_r($e));
}

$connectionInfo = array("UID" => "thaicreate-user@bc6hela9fr", "pwd" => "{your_password_here}", "Database" => "thaicreate-db", "LoginTimeout" => 30, "Encrypt" => 1);
$serverName = "tcp:bc6hela9fr.database.windows.net,1433";
$conn = sqlsrv_connect($serverName, $connectionInfo);

jdbc:sqlserver://bc6hela9fr.database.windows.net:1433;database=thaicreate-db;user=thaicreate-user@bc6hela9fr;password={your_password_here};encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;