I'm trying to show up the data from a table stored in an external database, using the Views and Data modules. As it's stored in the non-default database, I have adopt the table using the Data module.

The problem I have, is that when I try to open the contents of the table in the "Data tables" section, or in the view created, the query launched is wrong, and nothing is displayed.

The error message I get is: "user warning: Table 'debris_spatiaux.norad_objects' doesn't exist query:....". That's normal, as the table I've adopted ("norad_objects"), is not inside the database "debris_spatiaux" (which is the default one), is in a database called "deuxieme_debris_spatiaux" (the non-default one).

So, I don't know why, Data module is reading inside the wrong database. I've tested http://drupal.org/node/864184, which gives me "500 internal server error", and the http://drupal.org/node/894074, with no solution either.

My databases configuration in the settings.php file are:
$db_url['default'] = 'mysqli://debris_spatiaux:password@localhost/debris_spatiaux';
$db_url['deuxieme'] = 'mysqli://debris_spatiaux:password@localhost/deuxieme_debris_spatiaux';
$db_prefix = '';

Any help will be highly apreciated.

Thanks for advanced.