[development] ASP Integration with Drupal?

[Ron Dorman]

Khalid Baheyeldin wrote:
> On 8/15/07, *Ron Dorman* <rwd at simplydigtech.net 
> <mailto:rwd at simplydigtech.net>> wrote:
>
>     FGM wrote:
>     > If it's only two pages, why don't you just rewrite them in PHP ?
>     >
>
>     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?
>
>
> It exists, but has some caveats (mainly you have to set active to
> another db, and remember to set it back to Drupals afterwards).
>
> http://api.drupal.org/?q=api/function/db_set_active/HEAD
Thank you Khalid. Good info, but no support for the3rd parties MSSQL 
server in Drupal's abstraction layer, although I think I remember that 
someone was working it.

This may be a good starting place, thanks.

Ron D.