Using two databases

[eluser]rogierb[/eluser]
I'm confused, the second database is 'B' but in your example you load 'A' as the second database.
This would mean you have connected to 'A' twice.

On of our apps uses multi database. The key is to test all of your connection data and test if the server your code resides on, has access to that database.

Once you are satisfied all the connections work flawlessly, then build your second or third or whatever connection.
You won't have any problems, the way you connect to A

Code:

$this->a = $this->load->database('A',TRUE);
$result_set = $this->a->query($query);

Is the correct way to connect to another database