我知道这个问题已经问了100次
但我在这里真的很绝望
我使用Windows 7
通常,我使用Code Igniter将PHP和MYSQL编码为数据库
我用
xampp 1.8.1
[PHP:5.4.7]
在application \ config \ database.php中,我使用
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = '';
$db['default']['password'] = '';
$db['default']['database'] = 'test';
$db['default']['dbdriver'] = 'mysql';
$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;
在我的system \ database \ DB_driver.php里面
var $dbdriver = 'mysql';
var $dbprefix = '';
var $char_set = 'utf8';
var $dbcollat = 'utf8_general_ci';
var $autoinit = TRUE; // Whether to automatically initialize the DB
var $swap_pre = '';
var $port = '';
var $pconnect = FALSE;
var $conn_id = FALSE;
var $result_id = FALSE;
var $db_debug = FALSE;
var $benchmark = 0;
var $query_count = 0;
var $bind_marker = '?';
var $save_queries = TRUE;
var $queries = array();
var $query_times = array();
var $data_cache = array();
var $trans_enabled = TRUE;
var $trans_strict = TRUE;
var $_trans_depth = 0;
var $_trans_status = TRUE; // Used with transactions to determine if a rollback should occur
var $cache_on = FALSE;
var $cachedir = '';
var $cache_autodel = FALSE;
var $CACHE; // The cache class object
在我的控制器内部,我使用
$query = $this->db->query('SELECT * FROM asal');
foreach ($query->result_array() as $row)
{
echo $row['asalid'];
}
它完美地工作
但这是PHP的MySQL
现在,我需要将我的PHP与microsfot SQL Server 2008 R2连接
这就是我经历过的
首先,我从这里安装sqlsrv驱动程序(SQLSRV30.exe)
http://www.microsoft.com/en-us/download/details.aspx?id=20098
(它说PHP 5应该使用SQLSRV30)
接下来,我将其解压缩到我的php / ext
现在在我的php / ext中,我已经有8个其他文件从SQLSRV30.exe中提取为
php_sqlsrv_54_ts.dll
php_sqlsrv_53_ts.dll
php_sqlsrv_54_nts.dll
php_sqlsrv_53_nts.dll
php_pdo_sqlsrv_54_ts.dll
php_pdo_sqlsrv_53_ts.dll
php_pdo_sqlsrv_54_nts.dll
php_pdo_sqlsrv_53_nts.dll
然后,
我也尝试添加这些句子
extension=php_sqlsrv_54_nts.dll
extension=php_pdo_sqlsrv_54_nts.dll
在我的php.ini中
持续,
我将我的application \ config \ database.php更改为
$db['default']['hostname'] = 'NB-EDP-04\SQLEXPRESS';
$db['default']['username'] = '';
$db['default']['password'] = '';
$db['default']['database'] = 'test';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = FALSE;
$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;
还有我的system \ database \ DB_driver.php
var $dbdriver = 'sqlsrv';
var $dbprefix = '';
var $char_set = 'utf8';
var $dbcollat = 'utf8_general_ci';
var $autoinit = TRUE; // Whether to automatically initialize the DB
var $swap_pre = '';
var $port = '';
var $pconnect = FALSE;
var $conn_id = FALSE;
var $result_id = FALSE;
var $db_debug = FALSE;
var $benchmark = 0;
var $query_count = 0;
var $bind_marker = '?';
var $save_queries = TRUE;
var $queries = array();
var $query_times = array();
var $data_cache = array();
var $trans_enabled = TRUE;
var $trans_strict = TRUE;
var $_trans_depth = 0;
var $_trans_status = TRUE; // Used with transactions to determine if a rollback should occur
var $cache_on = FALSE;
var $cachedir = '';
var $cache_autodel = FALSE;
var $CACHE; // The cache class object
但不好,我在URL上输入localhost / edp后仍然出现此错误
Unable to connect to your database server using the provided settings.
Filename: C:\xampp\htdocs\edp\system\database\DB_driver.php
Line Number: 127
我使用Microsoft C#应用程序进行测试
我尝试连接到相同的数据库,并且有效
我可以选择该数据库内的表
所以我想,我的数据库的远程连接已经激活
请帮我谢谢
最佳答案
好吧,它解决了
我的问题是本地客户
我转到控制面板>程序和功能
我搜索“ Microsoft SQL Server 2008 R2本机客户端”
(因为我使用的是Microsoft SQL Server 2008 R2)
它会说,不建议您卸载本机客户端,但是可以,只要我们安装其他本机客户端即可
然后我下载
“ Microsoft SQL Server 2012本机客户端”
并且,它解决了,我不知道会发生什么,我只是知道,它可以帮助我的php应用程序连接到ms sql server 2008 R2