[eluser]Unknown[/eluser]
[quote author="HugoA" date="1263953354"]doing this the problem is solved.
Code:
$db['default']['pconnect'] = FALSE;
by default it is set to TRUE.
So, you can use
Code:
$db['default']['dbdriver'] = "mysql";
and call your stored procedures like this
Code:
$query = $this->db->query('CALL getPersona()');
I have to do more tests, but the application is working now.[/quote]
THANK YOU, THANK YOU, THANK YOU!!!
I was finding virtually nothing concerning this problem until I saw your post. I just started using mySQL stored procedures with my CodeIgniter application... and shortly after got the deadly "Unable to select the specified database" message.
I opened my \application\config\database.php file and changed from:
$db['default']['pconnect'] = TRUE;
to
$db['default']['pconnect'] = FALSE;
and <knock on wood> haven't had the same problem since.