+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Problems with Database connectivity using odbc Message: Undefined property: CI_Loader::$db (/showthread.php?tid=6268)
Problems with Database connectivity using odbc Message: Undefined property: CI_Loader::$db - El Forum - 02-20-2008
[eluser]Unknown[/eluser]
Not really sure what's going on. I can connect to the db through straight
Quote:Message: Undefined property: CI_Loader::$db
Filename: corpadmin/v_finduser.php
Line Number: 20
This is in my view page so i could test it.
Code:
$this->load->database('default');
/* line 20 */ $query = $this->db->query('select TOP 10 * from tb_people;');
print_r ($query);
if ($query->num_rows() > 0){
foreach ($query->result() as $row) {
echo $row->username;
echo $row->firstname;
echo $row->lastname;
}
}and from my database.php
Code:
$db['default']['hostname'] = "hostname or I've tried my freeTDS DSN";
$db['default']['username'] = "musername";
$db['default']['password'] = "ASLDFJASLDF";
$db['default']['database'] = "DBNAME";
$db['default']['dbdriver'] = "odbc";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";
$db['default']['port'] = "1433";Problems with Database connectivity using odbc Message: Undefined property: CI_Loader::$db - El Forum - 04-05-2012
[eluser]Unknown[/eluser]
config -> autoload.php
$autoload['libraries'] = array('database');