Wondering how to connect to SQL Azure databases? here are the connection string formats in ADO.Net , ODBC, PHP and JDBC to connect to the SQL Azure databases:
ADO.NET
Server=tcp:“{YourServer}”.database.windows.net,1433;Database=“{DatabaseName}”;User ID=“{UserNamer}”@”{YourServer}”;Password={your_password_here};Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;
ODBC
Driver={SQL Server Native Client 11.0};Server=tcp:“{YourServer}”.database.windows.net,1433;Database=“{DatabaseName}”;Uid=“{UserNamer}”@”{YourServer}”;Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;
PHP
Server: “{YourServer}“.database.windows.net,1433 \r\nSQL Database: “{DatabaseName}”\r\nUser Name: “{UserNamer}“\r\n\r\nPHP Data Objects(PDO) Sample Code:\r\n\r\ntry {\r\n $conn = new PDO ( \”sqlsrv:server = tcp:”{YourServer}”.database.windows.net,1433; Database = “{DatabaseName}”\”, \””{UserNamer}“\”, \“{your_password_here}\“);\r\n $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );\r\n}\r\ncatch ( PDOException $e ) {\r\n print( \”Error connecting to SQL Server.\” );\r\n die(print_r($e));\r\n}\r\n\rSQL Server Extension Sample Code:\r\n\r\n$connectionInfo = array(\”UID\” => \””{UserNamer}”@”{YourServer}”\”, \”pwd\” => \”{your_password_here}\”, \”Database\” => \””{DatabaseName}”\”, \”LoginTimeout\” => 30, \”Encrypt\” => 1, \”TrustServerCertificate\” => 0);\r\n$serverName = \”tcp:”{YourServer}”.database.windows.net,1433\”;\r\n$conn = sqlsrv_connect($serverName, $connectionInfo);
JDBC
jdbc:sqlserver://”{YourServer}”.database.windows.net:1433;database=”{DatabaseName}”;user=”{UserNamer}”@”{YourServer}”;password={your_password_here};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;