我可以使用什么方法在 codeigniter 和 sql server 之間創建連接？以下是我的連接方式，但似乎不起作用 $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);連接未建立，我不知道問題出在哪里
1 回答
開心每一天1111
TA貢獻1836條經驗 獲得超13個贊
$active_group = 'default'; $query_builder = TRUE; $db['default'] = array(
'dsn'? ?=> '',
'hostname' => 'computer_name\SQLEXPRESS',
'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_sqlsrv_72_ts_x64.dll、php_sqlsrv_72_nts_x64.dll、php_sqlsrv_72_ts_x64.dll 復制到 /php/ext。然后將它們添加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到/php/php.ini中。重新啟動阿帕奇
- 1 回答
- 0 關注
- 162 瀏覽
添加回答
舉報
0/150
提交
取消