Codeigniter 2.0.3 与 SQL Server Active Record

Question

我正在努力将在 1.7.2 上运行的 Codeigniter 应用程序升级到 2.0.3 但我无法连接到 SQL Server 。两个版本都在运行 php 5.2.10 的同一服务器上运行并连接到同一 SQL Server。

这是来自 CI 2.0.3 的错误

Unable to connect to your database server using the provided settings.
Filename: core/Loader.php
Line Number: 260

这是我正在使用的连接字符串，当然它适用于 1.7.2

$db['reports']['hostname'] = "mysqlserver";
$db['reports']['username'] = "sqluser";
$db['reports']['password'] = "sqlpass";
$db['reports']['database'] = "SQLReportDB";
$db['reports']['dbdriver'] = "mssql";
$db['reports']['dbprefix'] = "";
$db['reports']['pconnect'] = TRUE;
$db['reports']['db_debug'] = TRUE;
$db['reports']['cache_on'] = FALSE;
$db['reports']['cachedir'] = "";
$db['reports']['port']     = 972;

在控制器中我用这个调用连接

$report_db = $this->load->database('reports', TRUE);

下面是加载器文件中报告失败的函数。 第260行是return DB($params, $active_record);

/**
 * Database Loader
 *
 * @param   string  the DB credentials
 * @param   bool    whether to return the DB object
 * @param   bool    whether to enable active record (this allows us to override the config setting)
 * @return  object
 */
public function database($params = '', $return = FALSE, $active_record = NULL)
{
    // Grab the super object
    $CI =& get_instance();

    // Do we even need to load the database class?
    if (class_exists('CI_DB') AND $return == FALSE AND $active_record == NULL AND isset($CI->db) AND is_object($CI->db))
    {
        return FALSE;
    }

    require_once(BASEPATH.'database/DB.php');

    if ($return === TRUE)
    {
        return DB($params, $active_record);
    }

    // Initialize the db variable.  Needed to prevent
    // reference errors with some configurations
    $CI->db = '';

    // Load the DB class
    $CI->db =& DB($params, $active_record);
}

Answer 1

以下是我在连接到您未列出的 SQL Server 时使用的一些设置。可能是因为升级需要...

$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

Answer 2

$db['reports']['port'] 不再有效

需要在服务器末尾添加端口

$db['reports']['hostname'] = "mysqlserver:972";