<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><div style="RIGHT: auto"><SPAN style="RIGHT: auto">No, the $db_url method simply will not work because we cannot guarantee that the remote will always be accessible. If it's not, there is no reason why our site should not be. Once in a while (cron), we need to go get some data from that database; if it's not available at that time, we will merely log the error and <VAR id=yui-ie-cursor></VAR>try later.<BR style="RIGHT: auto" class=yui-cursor></SPAN></div>
<DIV></DIV>
<DIV style="RIGHT: auto"> </DIV>
<div style="RIGHT: auto"><FONT color=#ff007f size=4 face="bookman old style, new york, times, serif"><I><STRONG>Nancy</STRONG></I></FONT></div>
<div style="RIGHT: auto"> </div>
<div><FONT face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</FONT></div>
<div style="RIGHT: auto"><BR>
<BLOCKQUOTE style="BORDER-LEFT: rgb(16,16,255) 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; RIGHT: auto">
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><FONT size=2 face=Arial>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV style="BORDER-BOTTOM: #ccc 1px solid; BORDER-LEFT: #ccc 1px solid; PADDING-BOTTOM: 0px; LINE-HEIGHT: 0; MARGIN: 5px 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; HEIGHT: 0px; FONT-SIZE: 0px; BORDER-TOP: #ccc 1px solid; BORDER-RIGHT: #ccc 1px solid; PADDING-TOP: 0px" class=hr readonly="true" contenteditable="false"></DIV></DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Fred Jones</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"></FONT><BR style="RIGHT: auto">Not clear what the question is. does this help: http://drupal.org/node/18429<BR><BR>On Mon, Jul 11, 2011 at 9:35 PM, Ms. Nancy Wichmann wrote:<BR>> I know that the "standard" way to access another database is to include it<BR>> in $db_url in the settigs.php file. This has the undesireable effect that<BR>> the remote database must be available all the time. In my case, we only need<BR>> to access the remote DB a few times a week via a cron job, where much better<BR>> error handling is available. I haven't yet found a way (I'm still searching<BR>> DO) to do this. Does anyone have any good ideas? This is Drupal 6 - don't<BR>> bother suggesting an upgrade. Replication is probably not an option because<BR>> we shouldn't have access to, nor need, everything in the remote
DB.</DIV></DIV></BLOCKQUOTE></div></div></body></html>