[eluser]Unknown[/eluser]
I can not get dbforge to work at all with SQL server. I get an error from loader.php:
Message: Undefined property: C_ap1::$db
Filename: core/Loader.php
I have read tons of forums - can't seem to get around this one.
Here is SQL setup:
$db['sql1']['hostname'] = "sql";
$db['sql1']['username'] = "xxx";
$db['sql1']['password'] = "xxx";
$db['sql1']['database'] = "WCBH";
$db['sql1']['dbdriver'] = "mssql";
$db['sql1']['dbprefix'] = "";
$db['sql1']['pconnect'] = TRUE;
$db['sql1']['db_debug'] = TRUE;
$db['sql1']['cache_on'] = FALSE;
$db['sql1']['cachedir'] = "";
$db['sql1']['char_set'] = "utf8";
$db['sql1']['dbcollat'] = "utf8_general_ci";
...
class M_ap1 extends CI_Model {
function createCapViews($Sdate,$Edate)
{
$this->load->database('sql1', TRUE);
$this->load->dbutil();
$this->load->dbforge();//THIS BLOWS UP!!
$this->dbforge->drop_table('viewTEST');
....