windows2008 php5.3支持ms sql2008

最新推荐文章于 2024-11-08 16:00:10 发布

mfkzhounb

最新推荐文章于 2024-11-08 16:00:10 发布

阅读量121

点赞数

分类专栏： php 文章标签： php 操作系统数据库

本文链接：https://blog.csdn.net/mfkzhounb/article/details/84475013

版权

php 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

一、系统环境

操作系统：windows2008

php版本：5.3

数据库：sql2008

windows2008 sp1补丁

二、配制方法

修改php.ini文件，添加以下配制

extension=php_sqlsrv_53_ts.dll
extension=php_pdo_sqlsrv_53_ts.dll

根据版本进行选择

Driver file	PHP version	Thread safe?	Use with PHP .dll
php_sqlsrv_53_nts.dll php_pdo_sqlsrv_53_nts.dll	5.3	no	php5.dll
php_sqlsrv_53_ts.dll php_pdo_sqlsrv_53_ts.dll	5.3	yes	php5ts.dll
php_sqlsrv_54_nts.dll php_pdo_sqlsrv_54_nts.dll	5.4	no	php5.dll
php_sqlsrv_54_ts.dll php_pdo_sqlsrv_54_ts.dll	5.4	yes	php5ts.dll

三、测试代码

<?php
/*
Connect to the local server using Windows Authentication and specify
the AdventureWorks database as the database in use. To connect using
SQL Server Authentication, set values for the "UID" and "PWD"
 attributes in the $connectionInfo parameter. For example:
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>"AdventureWorks");
*/
$serverName = "(local)";
$connectionInfo = array( "Database"=>"AdventureWorks");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn )
{
     echo "Connection established.\n";
}
else
{
     echo "Connection could not be established.\n";
     die( print_r( sqlsrv_errors(), true));
}

//-----------------------------------------------
// Perform operations with connection.
//-----------------------------------------------

/* Close the connection. */
sqlsrv_close( $conn);
?>