Connecting to a second database

[strelitzia]

Hi,

I'm trying to get my cart to connect to a second db hosted on the same server as the original zc db.

I see that the db connection is referenced in includes/functions/sessions.php, includes/init_includes/init_database.php and admin/includes/init_includes/init_database.php.

I tried changing:

$db->connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE, USE_PCONNECT, false);

to:

$db->connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE, USE_PCONNECT, false);
$db2->connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE2, USE_PCONNECT, true);

after adding a define for DB_DATABASE2 to the configure.php files, but i get an error in the logs that says:

Call to a member function connect() on a non-object in /usr/local/zend/apache2/htdocs/devsites/newsite/newadmin/includes/init_includes/init_database.php on line 21

Does anyone know the best method of opening two db connections at the same time?

Thanks

[strelitzia]

Update on error logs:


Accessing admin,
Call to a member function connect() on a non-object in /usr/local/zend/apache2/htdocs/devsites/newsite/newadmin/includes/init_includes/init_database.php on line 21

Accessing the page in the shop that wants a connection to the second db,
Call to a member function connect() on a non-object in /usr/local/zend/apache2/htdocs/devsites/newsite/includes/functions/sessions.php on line 57
Call to a member function Execute() on a non-object in /usr/local/zend/apache2/htdocs/devsites/newsite/includes/templates/template_default/templates/tpl_product_info_display.php on line 65

No errors are recorded in the log going to index.php, or any other page in the shop.

store init_database.php line 23 was changed to:
if (!$db->connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE, USE_PCONNECT, false) AND $db2->connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE2, USE_PCONNECT, true)) {

[DrByte]

You can't use the $db2 variable until you've first declared it.