Welcome Guest, Not a member yet? Register   Sign In
dbforge and sql server
#1

[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');

....
#2

[eluser]Irfan Cikoglu[/eluser]
$config['db']['sql1'] ?
#3

[eluser]Unknown[/eluser]
I tried various flavors of that in line code and in config file.
It gave an error When I did $config[‘db’][‘sql1’]
So I tried $config[‘db’]= 'sql'; but got same error.

Has to be something about how SQL server code is set up.

Thanks for the suggestion!




Theme © iAndrew 2016 - Forum software by © MyBB