首先，更改

$db['default']['database'] = ‘elements;
$db['default']['dbdriver'] = ‘sq’lsrv;

到

$db['default']['database'] = 'elements';
$db['default']['dbdriver'] = 'sqlsrv';

在您的配置文件中。

第二个，驱动程序sqlsrv有问题。打开 /system/database/drivers/sqlsrv/sqlsrv_driver.php

Second, driver sqlsrv is buggy. Open /system/database/drivers/sqlsrv/sqlsrv_driver.php

允许 pconnect 在您的配置中，将行 89 从

To allow pconnect in your configuration, change line 89 from

$this->db_connect(TRUE);

到

return $this->db_connect(TRUE);

如果您想正确使用 affected_rows ，然后从

If you want to use affected_rows correctly, then change line 274 from

return @sqlrv_rows_affected($this->conn_id);

到

return @sqlsrv_num_rows($this->result_id);

我看到了许多有关如何修复 affected_rows 的建议>在其他地方发布，但是如果您还将sqlsrv用于会话，则将 _execute 更改为不使用 Scrollable 将会中断存储的会话验证。

I saw multiple suggestions of how to fix affected_rows posted elsewhere, but changing _execute to not use Scrollable will break stored sessions if you're also using sqlsrv for session validation.