[eluser]riza_nurhadi[/eluser]
and now for the adodb_driver.php [located @ system\database\drivers\adodb_driver.php]
this is the code.
i change function db_connect, db_pconnect so its used
php COM class
oh yea i forgot i also change function insert_id
just look at the code
Code:
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class CI_DB_adodb_driver extends CI_DB {
var $_count_string = "SELECT COUNT(*) AS ";
var $_random_keyword = ' ASC'; // not currently supported
function db_connect()
{
//this is the change
//return @mssql_connect($this->hostname, $this->username, $this->password);
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("Provider=SQLOLEDB; Data Source=".$this->hostname.";
Initial Catalog=".$this->database."; User ID=".$this->username."; Password=".$this->password."");
return $conn;
}
function db_pconnect()
{
//return @mssql_pconnect($this->hostname, $this->username, $this->password);
//return true;
return $this->db_connect();
}
function db_select()
{
//return @mssql_select_db($this->database, $this->conn_id);
return true;
}
function db_set_charset($charset, $collation)
{
// TODO - add support if needed
return TRUE;
}
function _execute($sql)
{
//$sql = $this->_prep_query($sql);
// return @mssql_query($sql, $this->conn_id);
$conn = $this->conn_id;
$rs = $conn->Execute($sql);
return $rs;
}
function insert_id()
{
// $ver = self::_parse_major_version($this->version());
// $sql = ($ver >= 8 ? "SELECT SCOPE_IDENTITY() AS last_id" : "SELECT @@IDENTITY AS last_id");
// $query = $this->query($sql);
// $row = $query->row();
// return $row->last_id;
$conn = $this->conn_id;
$sql = " SELECT @@IDENTITY AS last_id";
$rs = $conn->Execute($sql);
$insertid = $rs->Fields[0]->value;
return $insertid;
}
}
as you see i only copy this code from mssql driver