Connect to SQL Server using PDO

#3927353 – Pastie.

How to connect to SQL Server using PDO

try {
      $con = new PDO( "sqlsrv:server=$serverName;Database = $database", $uid, $pwd); 
      $con->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); 
   }

   catch( PDOException $e ) {
      die( "Error connecting to SQL Server" ); 
   }

Leave a Reply