php sql_srv链接sqlserver数据库 通达OAv12链接sqlserver数据库

<?
$dbhost = '122.xx.127.250,1433'; 
$dbuser ='sa'; //你的mssql用户名 
$dbpass = 'xx2022'; //你的mssql密码 
$dbname = 'sun1'; //你的mssql库名 

 $serverName = "122.xx.127.250";
 $connectionInfo = array( "Database"=>"sun1", "UID"=>"sa", "PWD"=>"xx2022");
 $conn = sqlsrv_connect( $serverName, $connectionInfo );
 if( $conn === false ) {
     die( print_r( sqlsrv_errors(), true));
 } else {
	   echo "连接成功!<br/>";
	 }


/*
$connect=odbc_connect("Driver={SQL Server};Server=$dbhost;Database=$dbname",$dbuser,$dbpass); 
 if($connect)
       {
       echo "连接成功!<br/>";
       } else {
		   echo "链接失败！";
		   }
		   
		   exit;
		   */

#$query = sqlsrv_query($conn, "select * from 数据库表");
    #while($row = sqlsrv_fetch_array($query))
    #{
    # print_r($row);
    #}
		   
 $sql="select * from table1";
 
$rs=sqlsrv_query($conn,$sql);  
//$rs=odbc_do($connect,$sql);  //do和exec都可以
if (!$rs) {
	 exit("Error in SQL");
	 }  
 
while($row = sqlsrv_fetch_array($rs))
{
    #{
    # print_r($row);
    #} 
  $a_id=$row["a_id"];  
  $name=$row["name"];  
  echo $a_id."**".$name."<br>";  
  
}  

 
$sql2="INSERT INTO [sun1].[dbo].[table1] ( [name], [beizhu]) VALUES ( 'sun33', '5533');SELECT SCOPE_IDENTITY();";
$query=sqlsrv_query($conn,$sql2);  
 sqlsrv_next_result($query);
$result=sqlsrv_fetch_array($query);
echo $result[0]; //返回新增的id
 exit;
 /*
$sql="insert into table (xxx) values (xxx);SELECT SCOPE_IDENTITY();";
$query=sqlsrv_query($db,$sql);
sqlsrv_next_result($query);
$result=sqlsrv_fetch_array($query);
echo$result[0];
*/





?>