首页 文章

无法从codeigniter 2.1.4连接到SQL Server 2012

提问于
浏览 次
0

Warning

发生数据库错误无法使用提供的设置连接到数据库服务器 . 文件名：D：\ xampp \ htdocs \ 214report \ system \ database \ DB_driver.php行号：124

Source code

办刊/配置/ database.php中

$ active_group ='default'; $ active_record = TRUE; $ db ['default'] ['hostname'] ='HOSTNAME'; $ db ['default'] ['username'] ='user'; $ db ['default'] ['password'] ='密码'; $ db ['default'] ['database'] ='报告'; $ db ['default'] ['dbdriver'] ='sqlsrv'; $ db ['default'] ['dbprefix'] =''; $ db ['default'] ['pconnect'] = TRUE; $ db ['default'] ['db_debug'] = TRUE; $ db ['default'] ['cache_on'] = FALSE; $ db ['default'] ['cachedir'] =''; $ db ['default'] ['char_set'] ='utf8'; $ db ['default'] ['dbcollat'] ='utf8_general_ci'; $ db ['default'] ['swap_pre'] =''; $ db ['default'] ['autoinit'] = TRUE; $ db ['default'] ['stricton'] = FALSE;

php.ini中

extension = php_pdo_sqlsrv_54_ts.dll扩展名= php_sqlsrv_54_ts.dll

Questions ?

怎么解决这个问题？

如果您需要，请向我索取更多源代码 .

php database sql-server-2012 codeigniter-2

1 回答

  • 0

    1）尝试查看是否满足所有系统的要求

    2）通过查看phpinfo（）来尝试查看是否加载了Sqlserv;

    根据MS网站http://www.microsoft.com/en-in/download/details.aspx?id=20098

    sqlserv的系统要求/支持的操作系统

    Windows 7，Windows 8，Windows 8.1，Windows Server 2008 R2，Windows Server 2008 Service Pack 2，Windows Vista Service Pack 2

    The following summarizes requirements. It will be important to see System Requirements (Microsoft Drivers for PHP for SQL Server) for more detail.

    Requires PHP 5.x. For information about how to download and install the latest stable binaries, visit http://windows.php.net for more detail.
    Version support for PHP is as follows
        Version 3.2 supports PHP 5.6, 5.5, and 5.4
        Version 3.1 supports PHP 5.5 and 5.4
        Version 3.0 supports PHP 5.4.

    For more detail and for supported operating systems, see System Requirements (Microsoft Drivers for PHP for SQL Server) .

    An Internet Information Services (IIS) Web server is required
    Versions 3.2 and 3.1 of the driver require Microsoft ODBC Driver 11 (or higher). You can download the Microsoft ODBC Driver 11 for SQL Server from the Microsoft® ODBC Driver 11 for SQL Server® - Windows page.
    Version 3.0 requires the x86 version of Microsoft SQL Server 2012 Native Client.
    Version 2.0 requires the x86 version of Microsoft SQL Server 2008 R2 Native Client.
    回复于

相关问题