php: Koneksi ke SQL Server via ODBC
$conn = odbc_connect('sqlserver', 'osd', 'osd');if (!$conn) {
die('Koneksi ke SQL Server via ODBC gagal: ' . mysql_errormsg());
}
echo 'Koneksi ke SQL Server via ODBC sukses !!'; echo "
";
$sql="SELECT * from apprv";
$rs=odbc_exec($conn,$sql);
if (!$rs){
exit("Error in SQL");
}
while (odbc_fetch_row($rs)){
$col1=odbc_result($rs, "serah");
$col2=odbc_result($rs, "terima");
echo "$col1"." - "."$col2"; echo "
";
}
odbc_close($conn);
?>