reestablishing the database connection
Posted: Wed Nov 15, 2006 8:15 am
back again
connection is made in the index.php file and each internal link in the site is opened
in a cell of that window.
now i need to make a connection to a different database while in the same site.
how do i establish a connection to the new database for this particular part of the page
while retaining the connection defined in the index.php
the connection in the index.php needs to be maintained because the link information
and the layout for the site is recorded in the first database.
i already tried closing the connection on top of the page and reopening it on the bottom
didn't work
connections:
new connection:
essential connection:
any suggestions on how i might go about doing this
connection is made in the index.php file and each internal link in the site is opened
in a cell of that window.
now i need to make a connection to a different database while in the same site.
how do i establish a connection to the new database for this particular part of the page
while retaining the connection defined in the index.php
the connection in the index.php needs to be maintained because the link information
and the layout for the site is recorded in the first database.
i already tried closing the connection on top of the page and reopening it on the bottom
didn't work
connections:
new connection:
Code: Select all
$objConn = new COM("adodb.connection");
$objConn->Open("dsn=@@@_Inventory;server=sr0005.@@@.net;database=ePO_SR0005;Trusted_Connection=yes");Code: Select all
$db = new COM("ADODB.Connection") or die("Kan ADO niet starten");
$db->Open("dsn=@@@_Inventory;server=sr0005.@@@.net;database=@@@_ICT;Trusted_Connection=yes");