Which PDO Connection String Should I Use for SQL Server with Microsoft Drivers?

Connecting to SQL Server with PDO and Microsoft Drivers

When attempting to connect to a SQL Server database using PHP Data Objects (PDO) with Microsoft's drivers, it can be unclear whether to use the 'sqlsrv' connection string or another option like 'odbc', 'dblib', or 'mssql'.

The recommended approach for connecting to SQL Server using PDO with Microsoft drivers is to use the 'sqlsrv' connection string. This string provides a more straightforward and reliable connection specifically tailored for Microsoft SQL Server.

Here is an example of how to properly establish a connection to a SQL Server database using PDO with the 'sqlsrv' connection string:

<?php
$host = 'YourAddress';
$database = 'YourDatabase';
$username = 'Username';
$password = 'Password';

$dsn = "sqlsrv:Server=$host;Database=$database";

try {
    $conn = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}
?>

In this example, the 'sqlsrv' connection string is used along with the necessary host, database, username, and password information. Once the connection is established, you can use the $conn variable to execute queries and perform database operations.

The above is the detailed content of Which PDO Connection String Should I Use for SQL Server with Microsoft Drivers?. For more information, please follow other related articles on the PHP Chinese website!