电脑为win7,php版本为5.3,sqlserver版本为2008,sqlsrv已经安装好并且成功了,但是使用sqlsrv_connect 函数却显示无法连接想问下这是为啥?

解决方案 »

  1.   

    <?php
    $serverName = "CY-20140813RBYS"; $connectionInfo = array( "Database"=>"CAP");
    $conn = sqlsrv_connect( $serverName, $connectionInfo);if( $conn ) {
         echo "Connection established.<br />";
    }else{
         echo "Connection could not be established.<br />";
         die( print_r( sqlsrv_errors(), true));
    }
    ?> 
    额额,这是我的sql_connect函数
      

  2.   

    $connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
      

  3.   


    改了,然后变成了网站无法显示该页面ORZ……<?php
     $serverName = "CY-20140813RBYS";  $connectionInfo = array( "Database"=>"CAP","UID"=sa,"PWD"="sa");
     $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn ) {
          echo "Connection established.<br />";
     }else{
          echo "Connection could not be established.<br />";
          die( print_r( sqlsrv_errors(), true));
     }
     ?> 
      

  4.   

    刚刚上面那个有点问题……但是改了之后还是一样的啊啊啊啊啊啊到底是为啥<html>
    <body><?php
      $serverName = "CY-20140813RBYS";   $connectionInfo = array("Database"=>"CAP","UID"="sa","PWD"="sa");
      $conn = sqlsrv_connect( $serverName, $connectionInfo);  if( $conn ) {
           echo "Connection established.<br />";
         
      }else{
           echo "Connection could not be established.<br />";
           die( print_r( sqlsrv_errors(), true));
      }
      ?> </body>
    </html>