ADODB - Connect multiple database without using PConnect

[volant]

Hi,

I am now using PConnect to connect multi-database for my developing system and it runs smoothly.
However, due to over jam and permanent connection of PConnect, my manager ask me find the solutions instead of using PConnect.
What i know is if i use $dbh->Connect() for multiple database, the query will always refer to primary database connection (the first connection created)
Any other possible ways to connect multiple database in ADODB instead of using PConnect?

Appreciate your help!

Volant

[Weedpacket]

Unless I'm mistaken, all you have to do is put each distinct connection in a distinct variable. Put a connection to the Foo database in a $foo_db variable, and a connection to the Bar database in a $bar_db variable, and then use the appropriate variable to communicate with the appropriate database. Really fancy would be $db['Foo'] and $db['Bar'].

I am certain that you don't have to call the variable "$dbh".

[volant]

so u mean put in an array?
but call a database connection in array..never do b4..:o