连接sql2008的问题
$db['js'] = array('dsn' => '',
'hostname' => '*********',
'username' => 'sa',
'password' => '************',
'database' => 'jstcc',
'dbdriver' => 'sqlsrv',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => TRUE,
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);
这是database代码,
public function getjs(){
$DB = $this->load->database('js',TRUE);
$sql = "select * from Identify";
$query = $DB->query($sql);
return $query->result_array();
}
这是调用的方法,显示
A PHP Error was encountered
Severity: Error
Message: Call to undefined function sqlsrv_connect()
Filename: sqlsrv/sqlsrv_driver.php
Line Number: 144
Backtrace:
我用的php5.6的版本
请大家帮忙看一下 你要先确保原生 PHP 可以读取 mssql 才行。CI 也是用的 PHP 函数来读取数据库的。 php 跟sqlsrv 要配对才行;我感觉这个方法挺麻烦的,配置文件要修改一大堆。你可以试一试odbc
页:
[1]