ThinkPHP 3.1.3 连接 MS SQL Server 2008 R2 

 1 <?php
 2 return array(
 3     'DB_TYPE' => 'Sqlsrv',
 4     'DB_HOST' => '127.0.0.1',
 5     'DB_PORT' => '1433',
 6     'DB_NAME' => 'demo',
 7     'DB_USER' => 'sa',
 8     'DB_PWD' => '',
 9     'DB_PREFIX' => 'demo_'
10 );
11 ?>

1.　　以上代码在项目配置目录Conf的 confgi.php配置文件中定义。

2.　　php扩展里要先安装MS SQL Server drivers for PHP （非PDO驱动）

3.　　服务器上要安装MS SQL Server Native Client 2012

 

用PDO驱动MS SQL Server 2008 R2方法如下：

<?php
    return array(
        'DB_TYPE' => 'pdo',
        'DB_HOST' => '127.0.0.1',
        'DB_PORT' => '1433',
        'DB_NAME' => 'demo',
        'DB_USER' => 'sa',
        'DB_PWD' => '',
        'DB_PREFIX' => 'demo_',
        'DB_DSN' => 'sqlsrv:Server=127.0.0.1; Database=demo'
　　);
?>

PDO 方式可简化为以下代码：

<?php
    return array(
        'DB_TYPE' => 'pdo',
        'DB_HOST' => '127.0.0.1',
        'DB_USER' => 'sa',
        'DB_PWD' => '',
        'DB_PREFIX' => 'demo_',
        'DB_DSN' => 'sqlsrv:Server=127.0.0.1; Database=demo'
　　);
?>

 

posted on 2013-10-07 08:29  redasurc  阅读(675)  评论(0)    收藏  举报

导航