ci 连接sql server

 

参考http://blog.csdn.net/yellowshit/article/details/46006197

extension=php_pdo_sqlsrv_56_ts.dll
extension=php_dblib.dll
extension=php_sqlsrv_56_ts.dll   //这个依赖也需要添加，参考的博主没有写这一步

ci datebase配置

$db['test2'] = array(
   'dsn'  => '',
   'hostname' => '10.10.0.65',
   'username' => 'sa',
   'password' => '123456',
   'database' => 'jk3',
   '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
);

 

转载于:https://www.cnblogs.com/helloworld8080/p/7609542.html