php:致命错误:调用未定义的函数 sqlsrv_connect() [英] php :Fatal error: Call to undefined function sqlsrv_connect()

问题描述

我有一个大问题，我希望在这里解决这个问题我尝试使用以下方法连接到 Sql Server 2008 R2:

I Have a big problem And I Wish get Solved for this problem here I Try to Connect to Sql Server 2008 R2 using:

1. php 5.6.11
2. Xampp 5.6.3
3. SQL Server 2008 r2
4. 使用 PHP 的 sql 服务器驱动程序 (php_pdo_sqlsrv_56_ts.dl &php_sqlsrv_56_ts.dll)

我尝试连接的代码是:

 $serverName = "Mahmoud-HP\SQL2008R2"; //serverName\instanceName
    $connectionInfo = array( "Database"=>"HR16", "UID"=>"Mahmoud", "PWD"=>"123" , "MultipleActiveResultSets" => false);
    $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));
    }

但是当运行页面时这条消息来找我

but when run the page this message come to me

致命错误:调用 C:\xampp\htdocs\testsqlserver\index.php 中未定义的函数 sqlsrv_connect()

Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs\testsqlserver\index.php on

这个问题的解决方案是什么

What is solution for this problem

推荐答案

您必须使用 SQL Server 本机驱动程序进行 php.

you have to use the SQL Server native driver for php.

从这里下载:

https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=20098

示例代码:

$serverName = "tcp:ServerID.database.windows.net, 1433";

$connectionOptions = array("Database" => "DatabaseName", 

                           "UID" => "Username@ServerID",

                           "PWD" => "password");

$conn = sqlsrv_connect($serverName, $connectionOptions);



if($conn === false)

{

    die(print_r(sqlsrv_errors(), true));

}

编辑

确保加载列出的两个 dll:

Make sure you load BOTH dll's listed:

extension=php_sqlsrv_56_ts.dll

和

extension=php_pdo_sqlsrv_56_ts.dll

这篇关于php:致命错误:调用未定义的函数 sqlsrv_connect()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！