Codeigniter:如何设置与SQL Server的连接(2008) [英] Codeigniter: How to setup connection to a SQL server (2008)
问题描述
我已经花了很多天的时间完成这项任务,直到现在我还是看不到结局。在过去一天,我成功地在我的PHP环境中安装sqlsrv驱动程序,但现在当我尝试连接时,我收到此消息:
I've spent many days on this task, and I can't see the end until now. In the past day I managed to install sqlsrv driver on my PHP environment successfully but now when I try to connect I get this message:
使用提供的设置连接到您的数据库服务器。
Unable to connect to your database server using the provided settings.
我的设置在 application / config / database.php
的定义如下:
My settings in application/config/database.php
are so defined:
$db['dbname']['hostname'] = "ENJ01\SQLEXPRESS";
$db['dbname']['username'] = "user";
$db['dbname']['password'] = "password";
$db['dbname']['database'] = "dbname";
$db['dbname']['dbdriver'] = "sqlsrv";
$db['dbname']['dbprefix'] = "";
$db['dbname']['pconnect'] = TRUE;
$db['dbname']['db_debug'] = TRUE;
$db['dbname']['cache_on'] = FALSE;
$db['dbname']['cachedir'] = "";
$db['dbname']['char_set'] = "utf8";
$db['dbname']['dbcollat'] = "utf8_general_ci";
$db['dbname']['swap_pre'] = '';
$db['dbname']['autoinit'] = TRUE;
$db['dbname']['stricton'] = FALSE;
有什么不对吗?
配置:
- wampserver 2.4 x86
- PHP 5.4.16
- sqlsrv驱动程序 - > php_sqlsrv_54_ts.dll
- Codeigniter 2.1.4
- wampserver 2.4 x86
- PHP 5.4.16
- sqlsrv driver -> php_sqlsrv_54_ts.dll
- Codeigniter 2.1.4
推荐答案
我有一年前遇到过的麻烦。看看这里的回复,有一些很好的建议从那里: CodeIgniter MSSQL连接
I've had the same trouble you've had about a year ago. Have a look at the replies here, there are some great suggestions from people in there: CodeIgniter MSSQL connection
此外,几天前在这里发布了一个线程: CI连接到SQL SERVER - 检查我的答案,因为它解决了特定开发人员的问题。
Also, a thread was posted a few days ago here: CI connect to SQL SERVER - check out my answer over there as well, since it's solved the problem for that particular developer.
这篇关于Codeigniter:如何设置与SQL Server的连接(2008)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!