[development] ASP Integration with Drupal?

Tao Starbow starbow at citris-uc.org
Wed Aug 15 18:36:14 UTC 2007

Ron Dorman wrote:
> I would love to to. I have built php that connected directly to MSSQL 
> on a backoffice system. I have never before thought about having php 
> connect to two different db servers in the same app.
> We would use the MySQL on the client server for Drupal, then need to 
> connect to the 3rd party MSSQL for the small bits of data from the 3rd 
> party inserted into the two pages.
> I have not seen that Drupal has the capability to support and connect 
> to two different db's. Is there such capability I have not found yet?
This is one of the cooler, not-so-well known drupal features.  In 
settings.php you can define $db_url as an array
$db_url['default'] = normal drupal string
$db_url['backoffice'] = other mysql connect string

then you use db_set_active( db_key ) to switch between them as needed.

More information about the development mailing list