database connectivity problem - Printable Version

database connectivity problem - Printable Version

+- 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: database connectivity problem (/showthread.php?tid=6273)

database connectivity problem - El Forum - 02-20-2008

[eluser]sawatdee[/eluser]
I am getting an error that says, "Unable to select the specified database: mydatabase", when I try to load my database. I am using CodeIgniter 1.6.0.

Here is the configuration array in my config file.

Code:
$active_group = "local";

$active_record = TRUE;

$db['local']['hostname'] = "localhost";

$db['local']['username'] = "username";

$db['local']['password'] = "password";

$db['local']['database'] = "mydatabase";

$db['local']['dbdriver'] = "mysql";

$db['local']['dbprefix'] = "";

$db['local']['pconnect'] = TRUE;

$db['local']['db_debug'] = TRUE;

$db['local']['cache_on'] = FALSE;

$db['local']['cachedir'] = "";

$db['local']['char_set'] = "utf8";

$db['local']['dbcollat'] = "utf8_general_ci";

And here is the controller code I am using to load it. I am not autoloading the database library.

Code:
$table_data = array ();

$table_data ['column1'] = $data1;

$table_data ['column2'] = $data2;

$table_data ['column3'] = $data3;

$this->load->database ('local');

$this->db->insert ('mytable', $table_data);

I previously used CodeIgniter 1.5.4 and the database code worked prefectly. Some things have changed in version 1.6.0 and I am wondering if anyone else has had this problem, or if anyone can see something in my code that I am doing wrong.

database connectivity problem - El Forum - 02-21-2008

[eluser]Clooner[/eluser]
Change username?