I can not connect to SQL Server 2008 evolution ; from fast CGI PHP on IIS8 and windows server 2012; using Microsoft Drivers for PHP for SQL Server, SQLSRV30.EXE and PHP 5.4.9


  • Cornered

    I used windows 2003 r2 sql 2005 php 5.2.17 everything was perfect until it appears the windows 2012 now with such a php 5.4.9 sql 2008 evolution
    I read that he does not have to support more and php_mssql.dll sending me ta use SQLSRV in place also read that difference will give another topic said it was mistake Numas lib or path windows
    the question as I do to put this MACHINE work without having to mess in my code or not no way

    ------------------MSSQL TO SQLSRV ----------------------------------------------
    $myServer = "";
    $myUser = "";
    $myPass = "";
    $myDB = "";
    $sqlString =$_POST['parametros'];

    $s = mssql_connect($myServer, $myUser, $myPass) or die("N�o foi possivel se conectar a $myServer");

    $d = mssql_select_db($myDB, $s) or die("O Banco de dados $myDB nao pode ser aberto");


    $results= mssql_query($sqlquery);

    $Campos = mssql_num_fields($results);

    $row = mssql_fetch_array($results);

    for ($i = 0; $i < $Campos; $i++ ) {
    echo mssql_field_name($results, $i); 
    echo '='.$row[$i].';';




    I need to then do the same using the PHP API RUN SQLSRV
    can someone help me?


    • Edited by patrick2505 Friday, January 25, 2013 6:22 PM
    Friday, January 25, 2013 6:09 AM

All replies