On 8/15/07, <b class="gmail_sendername">Ron Dorman</b> <<a href="mailto:rwd@simplydigtech.net">rwd@simplydigtech.net</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
FGM wrote:<br>> If it's only two pages, why don't you just rewrite them in PHP ?<br>><br><br>I would love to to. I have built php that connected directly to MSSQL on<br>a backoffice system. I have never before thought about having php
<br>connect to two different db servers in the same app.<br><br>We would use the MySQL on the client server for Drupal, then need to<br>connect to the 3rd party MSSQL for the small bits of data from the 3rd<br>party inserted into the two pages.
<br><br>I have not seen that Drupal has the capability to support and connect to<br>two different db's. Is there such capability I have not found yet?</blockquote><div><br>It exists, but has some caveats (mainly you have to set active to
<br>another db, and remember to set it back to Drupals afterwards).<br><br><a href="http://api.drupal.org/?q=api/function/db_set_active/HEAD">http://api.drupal.org/?q=api/function/db_set_active/HEAD</a> <br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> Beyond this, the question is what these ASP (raw ASP, or <a href="http://ASP.NET">ASP.NET</a> ?) data<br>> are: you might also want to modify the ASP pages so that they export their<br>> data to Drupal over SOAP: SOAP integration is integral to both
<a href="http://ASP.NET">ASP.NET</a> and<br>> PHP5.2, and writing a SOAP server in PHP is trivial.<br>><br><br>The current pages are raw ASP. But again, one is the main/home page. If<br>the sites is accessed with a sub-folder in the URL
<br>(<a href="http://www.example.com/sub1">www.example.com/sub1</a>) the ASP (index.asp) page reads the backoffice<br>server for a registered associate with an ID of the sub-folder name. If<br>it finds such an associate, it inserts the associate name into the
<br>template for display throughout the site and sets a cookie with the<br>associate ID in it. To run Drupal, we need index.php to be first in line<br>preempting the index.asp page.<br><br>I would have to modify Drupal to get the data from the 3rd party server
<br>before rendering the initial page.<br><br>> ----- Original Message -----<br>> From: "Ron Dorman" <<a href="mailto:rwd@simplydigtech.net">rwd@simplydigtech.net</a>><br>> To: <<a href="mailto:development@drupal.org">
development@drupal.org</a>><br>> Sent: Wednesday, August 15, 2007 8:00 PM<br>> Subject: [development] ASP Integration with Drupal?<br>><br>><br>><br>>> A client wants to move an existing site to Drupal.
<br>>><br>>> The catch is that the existing site has two pages that are ASP. The ASP<br>>> pages connect to a 3rd party hosted backoffice package and database.<br>>><br>>> The clients current site is on a dedicated leased Win / IIS / Plesk
<br>>> Control Panel server. The Plesk package provides php 5.2 and MySQL 5 so<br>>> I do not believe we will have any issues installing and running Drupal<br>>> on the server.<br>>><br>>> Does anyone know of any development, module, etc. that would allow us to
<br>>> integrate the ASP data into Drupal?<br>>><br>>> Any other gotchas I should be looking for?<br>>><br>>> Thank you all for the work you do and for the Drupal software.<br>>><br>>> Ron D.
<br><br><br>--<br>Ron Dorman<br>Simply Digital Technologies<br><a href="http://www.simplydigtech.net">www.simplydigtech.net</a><br><a href="mailto:rwd@simplydigtech.net">rwd@simplydigtech.net</a><br>817-503-7704 ofc<br>817-503-7719 fax
<br>817-528-8947 cell<br><br></blockquote></div><br><br clear="all"><br>-- <br><a href="http://2bits.com">2bits.com</a><br><a href="http://2bits.com">http://2bits.com</a><br>Drupal development, customization and consulting.