Khalid Baheyeldin wrote:
On 8/15/07, *Ron Dorman* <rwd@simplydigtech.net <mailto:rwd@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.