Login

02-01-2008, 04:19 AM

[eluser]zyddee[/eluser]
ah, now i get it to connect..
BUT i get an error on num_rows() when i use ODBC-connection

Code:
// DB Config --------------

        $config['hostname'] = $data['adress'];

        $config['username'] = $data['username'];

        $config['password'] = $data['password'];

        $config['database'] = $data['db'];

        $config['dbdriver'] = $data['driver'];

        $config['dbprefix'] = "";

        $config['pconnect'] = FALSE;

        $config['db_debug'] = TRUE;

        $config['active_r'] = TRUE;

        // ------------------------

        if( $data['driver'] == strtolower('mssql') )

            $conn = mssql_connect($data['adress'],$data['username'],$data['password']);

        else if( $data['driver'] == strtolower('odbc') )

            $conn = odbc_connect($data['adress'],$data['username'],$data['password']);

        if(is_resource($conn)){ 

            $DB_MSSQL = $this->load->database($config, TRUE);

        }

        else {

            return 'Kunde inte ansluta till databasen';

        }

        $this->table = 'employee';

        $DB_MSSQL->where('a', $a);

        $DB_MSSQL->where('b', $b);

        $DB_MSSQL->select('a,b');

        $query =  $DB_MSSQL->get($this->table);

        if ( $query->num_rows() == 1 ) //<- error (Call to a member function num_rows() on a non-object in)

        {    

            $data2 = $query->row_array();

        }

Call to a member function num_rows() on a non-object in