Skip to content

Commit 14b4264

Browse files
TOC updated, links fixed
1 parent 5f0d7be commit 14b4264

3 files changed

Lines changed: 7 additions & 6 deletions

File tree

docs/connect/php/TOC.md

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -20,13 +20,15 @@
2020
## [Connecting to the Server](connecting-to-the-server.md)
2121
### [How to: Connect Using Windows Authentication](how-to-connect-using-windows-authentication.md)
2222
### [How to: Connect Using SQL Server Authentication](how-to-connect-using-sql-server-authentication.md)
23+
### [How to: Connect Using Azure Active Directory Authentication](azure-active-directory.md)
2324
### [How to: Connect on a Specified Port](how-to-connect-on-a-specified-port.md)
2425
### [Connection Pooling](connection-pooling-microsoft-drivers-for-php-for-sql-server.md)
2526
### [How to: Disable Multiple Active Resultsets (MARS)](how-to-disable-multiple-active-resultsets-mars.md)
2627
### [Connection Options](connection-options.md)
2728
### [PHP Driver for SQL Server Support for LocalDB](php-driver-for-sql-server-support-for-localdb.md)
2829
### [PHP Driver for SQL Server Support for High Availability, Disaster Recovery](php-driver-for-sql-server-support-for-high-availability-disaster-recovery.md)
2930
### [Connecting to Microsoft Azure SQL Database](connecting-to-microsoft-azure-sql-database.md)
31+
### [Connection Resiliency](connection-resiliency.md)
3032
## [Comparing Execution Functions](comparing-execution-functions.md)
3133
## [Direct Statement Execution and Prepared Statement Execution in the PDO_SQLSRV Driver](direct-statement-execution-prepared-statement-execution-pdo-sqlsrv-driver.md)
3234
## [Retrieving Data](retrieving-data.md)
@@ -126,4 +128,3 @@
126128
# [Code Samples](code-samples-for-php-sql-driver.md)
127129
## [Example Application (PDO_SQLSRV Driver)](example-application-pdo-sqlsrv-driver.md)
128130
## [Example Application (SQLSRV Driver)](example-application-sqlsrv-driver.md)
129-

docs/connect/php/azure-active-directory.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,7 @@ author: "david-puglielli"
99
ms.author: "v-dapugl"
1010
manager: "v-hakaka"
1111
---
12-
# How to: Connect Using Azure Active Directory Authentication
12+
# Connect Using Azure Active Directory Authentication
1313
[!INCLUDE[Driver_PHP_Download](../../includes/driver_php_download.md)]
1414

1515
[Azure Active Directory](https://docs.microsoft.com/en-us/azure/active-directory/active-directory-whatis) (Azure AD) is a central user ID management technology that operates as an alternative to [SQL Server authentication](../../connect/php/how-to-connect-using-sql-server-authentication.md). Azure AD allows connections to Microsoft Azure SQL Database and SQL Data Warehouse with federated identities in Azure AD using a username and password, Windows Integrated Authentication, or an Azure AD access token; the PHP drivers for SQL Server offer partial support for these features.
@@ -24,7 +24,7 @@ To use Azure AD, use the **Authentication** keyword. The values that **Authentic
2424

2525
The **Authentication** keyword affects the connection security settings. If it is set in the connection string, then by default the **Encrypt** keyword is set to true, so the client will request encryption. Moreover, the server certificate will be validated irrespective of the encryption setting unless **TrustServerCertificate** is set to true. This is distinguished from the old, and less secure, login method, in which the server certificate is not validated unless encryption is specifically requested in the connection string.
2626

27-
Before using Azure AD with the PHP drivers for SQL Server on Windows, ensure that you have installed the [Microsoft Online Services Sign-In Assistant](https://www.microsoft.com/en-ca/download/details.aspx?id=41950) (not required for Linux and MacOS).
27+
Before using Azure AD with the PHP drivers for SQL Server on Windows, ensure that you have installed the [Microsoft Online Services Sign-In Assistant](https://www.microsoft.com/download/details.aspx?id=41950) (not required for Linux and MacOS).
2828

2929
#### Limitations
3030

docs/connect/php/connection-resiliency.md

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -9,10 +9,10 @@ author: "david-puglielli"
99
ms.author: "v-dapugl"
1010
manager: "v-hakaka"
1111
---
12-
## Idle Connection Resiliency
12+
# Idle Connection Resiliency
1313
[!INCLUDE[Driver_PHP_Download](../../includes/driver_php_download.md)]
1414

15-
[Connection resiliency](https://msdn.microsoft.com/en-us/library/dn632678.aspx) is the principle that a broken idle connection can be reestablished, within certain constraints. If a connection to Microsoft SQL Server fails, connection resiliency allows the client to automatically attempt to reestablish the connection. Connection resiliency is a property of the data source; only SQL Server 2014 and later and Azure SQL Database support connection resiliency.
15+
[Connection resiliency](https://msdn.microsoft.com/library/dn632678.aspx) is the principle that a broken idle connection can be reestablished, within certain constraints. If a connection to Microsoft SQL Server fails, connection resiliency allows the client to automatically attempt to reestablish the connection. Connection resiliency is a property of the data source; only SQL Server 2014 and later and Azure SQL Database support connection resiliency.
1616

1717
Connection resiliency is implemented with two connection keywords that can be added to connection strings: **ConnectRetryCount** and **ConnectRetryInterval**.
1818

@@ -38,7 +38,7 @@ Connection resiliency applies when the connection is idle. Failures that occur w
3838

3939
## Example
4040

41-
The following code connects to a database and executes a query. The connection is interrupted by killing the session and a new query is attempted using the broken connection. This example uses the [AdventureWorks](https://msdn.microsoft.com/en-us/library/ms124501%28v=sql.100%29.aspx) sample database.
41+
The following code connects to a database and executes a query. The connection is interrupted by killing the session and a new query is attempted using the broken connection. This example uses the [AdventureWorks](https://msdn.microsoft.com/library/ms124501%28v=sql.100%29.aspx) sample database.
4242

4343
In this example, we specify a buffered cursor before breaking the connection. If we do not specify a buffered cursor, the connection would not be reestablished because there would be an active server-side cursor and thus the connection would not be idle when broken. However, in that case we could call sqlsrv_free_stmt() before breaking the connection to vacate the cursor, and the connection would be successfully reestablished.
4444

0 commit comments

Comments
 (0)