How can the error "SQLSTATE[IM002] SQLConnect: 0 [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben" be resolved when attempting to connect to MSSQL with PDO in PHP?

The error "SQLSTATE[IM002] SQLConnect: 0 [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben" occurs when the data source name is not found or no default driver is specified when trying to connect to MSSQL with PDO in PHP. To resolve this issue, you need to ensure that the correct data source name (DSN) is provided in the connection string. 

$dsn = 'sqlsrv:Server=server_name;Database=database_name';
$user = 'username';
$password = 'password';

try {
    $conn = new PDO($dsn, $user, $password);
    echo "Connected successfully";
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

Keywords

SQLSTATE IM002 SQLConnect ODBC Driver Manager MSSQL.

Related Questions