dongsha2792 2015-11-13 11:19
浏览 161
已采纳

在PHP中使用sqlsrv执行存储过程

I'm executing a stored procedure using sqlsrv in a php code like this:

    $tsql_callSP = "{call cnt.stproc1(?)}";
    $rotCode = '1111';
    $params = array( 
                     array($rotCode, SQLSRV_PARAM_IN),
                   );

    $serverName = "xxxxxxx\wwwwwww"; //serverName\instanceName
    $connectionInfo = array( "Database"=>"aaaaaaaaaaa", "UID"=>"bbbbbbb", "PWD"=>"ccccccc");
    $conn = sqlsrv_connect( $serverName, $connectionInfo);

    /* Execute the query. */
    $stmt3 = sqlsrv_query( $conn, $tsql_callSP, $params);
    if( $stmt3 === false )
    {
         echo "Error in executing statement 3.
";
         die( print_r( sqlsrv_errors(), true));
    }

The Stored Procedure is executed in the DB successfully and does what it has to do, but in my php code i always fall in the failiure if (stmt3 === false) receiving the following error:

     Array ( [0] => Array ( [0] => 01000 [SQLSTATE] => 01000 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]0510620150922777 [message] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]0510620150922777 ) [1] => Array ( [0] => 01000 [SQLSTATE] => 01000 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]UPDATE 004 [message] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]UPDATE 004 ) )

What is wrong here? why does it get executed well, but the driver handles me this error?

  • 写回答

1条回答 默认 最新

  • dongyishen5796 2015-11-13 11:28
    关注

    Done. It was not an error, just a warning. However, sqlsrv treats warnings as errors unless told otherwise with:

        sqlsrv_configure("WarningsReturnAsErrors", 0);
    

    Thanks anyway.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
编辑
预览

报告相同问题?

悬赏问题

  • ¥15 PADS Logic 原理图
  • ¥15 PADS Logic 图标
  • ¥15 电脑和power bi环境都是英文如何将日期层次结构转换成英文
  • ¥20 气象站点数据求取中~
  • ¥15 如何获取APP内弹出的网址链接
  • ¥15 wifi 图标不见了 不知道怎么办 上不了网 变成小地球了
手机看
程序员都在用的中文IT技术交流社区

程序员都在用的中文IT技术交流社区

专业的中文 IT 技术社区,与千万技术人共成长

专业的中文 IT 技术社区,与千万技术人共成长

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

客服 返回
顶部