[development] ASP Integration with Drupal?

[Khalid Baheyeldin]

On 8/15/07, Ron Dorman <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

> Beyond this, the question is what these ASP (raw ASP, or ASP.NET ?) data
> > are: you might also want to modify the ASP pages so that they export
> their
> > data to Drupal over SOAP: SOAP integration is integral to both ASP.NETand
> > PHP5.2, and writing a SOAP server in PHP is trivial.
> >
>
> The current pages are raw ASP. But again, one is the main/home page. If
> the sites is accessed with a sub-folder in the URL
> (www.example.com/sub1) the ASP (index.asp) page reads the backoffice
> server for a registered associate with an ID of the sub-folder name. If
> it finds such an associate, it inserts the associate name into the
> template for display throughout the site and sets a cookie with the
> associate ID in it. To run Drupal, we need index.php to be first in line
> preempting the index.asp page.
>
> I would have to modify Drupal to get the data from the 3rd party server
> before rendering the initial page.
>
> > ----- Original Message -----
> > From: "Ron Dorman" <rwd at simplydigtech.net>
> > To: <development at drupal.org>
> > Sent: Wednesday, August 15, 2007 8:00 PM
> > Subject: [development] ASP Integration with Drupal?
> >
> >
> >
> >> A client wants to move an existing site to Drupal.
> >>
> >> The catch is that the existing site has two pages that are ASP. The ASP
> >> pages connect to a 3rd party hosted backoffice package and database.
> >>
> >> The clients current site is on a dedicated leased Win / IIS / Plesk
> >> Control Panel server. The Plesk package provides php 5.2 and MySQL 5 so
> >> I do not believe we will have any issues installing and running Drupal
> >> on the server.
> >>
> >> Does anyone know of any development, module, etc. that would allow us
> to
> >> integrate the ASP data into Drupal?
> >>
> >> Any other gotchas I should be looking for?
> >>
> >> Thank you all for the work you do and for the Drupal software.
> >>
> >> Ron D.
>
>
> --
> Ron Dorman
> Simply Digital Technologies
> www.simplydigtech.net
> rwd at simplydigtech.net
> 817-503-7704 ofc
> 817-503-7719 fax
> 817-528-8947 cell
>
>


-- 
2bits.com
http://2bits.com
Drupal development, customization and consulting.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20070815/fc2f08b4/attachment-0001.htm