จะ Connect SQL Server 2005 ผ่าน OBDC ต่าง Server ครับ

define("Dns2","vmServer2");
define("UserName2","sa");
define("PassWord2","1234");
define("Tb_Test","test")

function ConnectServer($dns,$username,$password) {
$objConnect= odbc_connect($dns, $username, $password) or die("Error Connect to Database $dns"); 
}

function  showdata( $objQuery ){
	while($objResult = odbc_fetch_array($objQuery)) 
	{  echo "Sale Amount (Actual) = ".$objResult['Sale Amount (Actual)']." <br>";
		echo "Location Code  = ".$objResult['Location Code']."<br>"; 
		echo "Posting Date   = ".$objResult['Posting Date']."<br>"; 
		}
}

ConnectServer(Dns2,UserName2,PassWord2);
$strSQL = "SELECT * ";
$strSQL .= "FROM ".Tb_Test; 
$objQuery =  odbc_exec($objConnect,$strSQL) or die ("Error Query"); 
echo "<br>Data From Server ".Dns2." <br>";
showdata($objQuery);
odbc_close($objConnect);