Hello there,
Ive been using PEAR😃B until recently when it started having problems using 2 simultanious connections to different servers. So i thought i would try upgrading to PEAR:MDB2 in the hope that this will allow me to do what i need.
Anyway basically i have 2 DB servers, one holds user information one holds product information, so ive made 2 connections however its like there can only ever be ONE connection at once.
The process im going through in psudo code is:
$oDB1 = new MDB2(); // user database
$oDB2 = new MDB2(); // product database
$oDB1->connect($dsn1);
$oDB2->connect($dsn2);
$oDB1->queryAll("show tables");
This then brings back all the tables that are in the product database, not the user one which it should be doing. Can anyone offer any advice about this? and if MDB2 does acctually support doing stuff like this?
DB used to seem to work ok until i needed to disconnect, and as soon as i tried to do that it just said that it was already disconnected, which like this made it look like there is just 1 global connection object somewhere that can only point to one DB at a time... and im stumpped...
