Contoh Coding : Konek ke MSSQL dari php

Berikut Contoh Coding : Konek ke MSSQL dari php

<?php
$conn = new COM ("ADODB.Connection") or die("Cannot Start Ado");
$connStr='PROVIDER=SQLOLEDB;SERVER=localhost;UID=sa;PWD=passwordq;DATABASE=userku';
$conn->open($connStr);

$sSQL = "select * from userku.dbo.daftarUser ";

$rs4=$conn->execute($sSQL);

while(!$rs4->EOF)
{
    echo (trim($rs4['nama']);
    $rs4->MoveNext();
}
?>