有没有一种方法可以使用php 7.2版在codeigniter 3和sqlserver之间创建连接



我可以用什么方法在codeigniter和sqlserver之间创建连接?下面是我连接的方式,但它似乎不起作用

$active_group = 'default'; $query_builder = TRUE; $db['default'] = array(
'dsn'   => '',
'hostname' => 'localhost',
'port' => '1433',
'username' => 'username',
'password' => '*****',
'database' => 'database_name',
'dbdriver' => 'mssql',
'dbprefix' => '',
'pconnect' => FALSE,
// 'db_debug' => (ENVIRONMENT !== 'production'),
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE

);

连接没有建立,我不知道出了什么问题

$active_group = 'default'; $query_builder = TRUE; $db['default'] = array(
'dsn'   => '',
'hostname' => 'computer_nameSQLEXPRESS',
'port' => '1433',
'username' => 'username',
'password' => '*****',
'database' => 'database_name',
'dbdriver' => 'sqlsrv',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => (ENVIRONMENT !== 'production'),
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE

);

首先,我需要在我的计算机上安装sql server php驱动程序安装扩展插件。下载驱动程序,然后提取并复制php_pdo_sqlsrv-72_nts_x64.dll、php_pdo_Sqlsrv72_ts_x64.dll、php_sqlsrv 72_nts_x64.dll、php_sqlsrv_72_tsx64.dll到/php/ext。然后在/php/php.ini中添加这些extension=php_pdo_sqlsrv_72_nts_x64.dll extension=php_pdo_sqlsrv_72_ts_x64.dll extension=php_sqlsrv_72_nts_x64.dll extension=php_sqlsrv_72_ts_x64.dll。重新启动apache

最新更新