我可以使用什么方法在 codeigniter 和 sql server 之間創(chuàng)建連接？以下是我的連接方式，但似乎不起作用 $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);連接未建立，我不知道問(wèn)題出在哪里
1 回答
開(kāi)心每一天1111
TA貢獻(xiàn)1836條經(jīng)驗(yàn) 獲得超13個(gè)贊
$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
);
首先，我需要在我的計(jì)算機(jī)上安裝 sql server php 驅(qū)動(dòng)程序來(lái)安裝擴(kuò)展。下載驅(qū)動(dòng)程序然后解壓，然后將 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 復(fù)制到 /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中。重新啟動(dòng)阿帕奇
- 1 回答
- 0 關(guān)注
- 175 瀏覽
添加回答
舉報(bào)
0/150
提交
取消