[development] ASP Integration with Drupal?

[Larry Garfield]

On Wednesday 15 August 2007, Ron Dorman 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?

Drupal 5 and Drupal 6 can easily connect to two different databases of the 
same type (both MySQL or both Postgres).  However, the Drupal database API 
doesn't support MS SQL right now anyway.

However, there's nothing stopping you from opening up a connection to another 
database using mysqli_, mssql_, or PDO in your own code and bypassing 
Drupal's database APIs completely.  I'm working on a project now where we 
have not one but 2 3rd party packages embedded in wrapper modules.  One uses 
mysqli_ internally, the other uses ADODB internally.  Works just fine.

-- 
Larry Garfield			AIM: LOLG42
larry at garfieldtech.com		ICQ: 6817012

"If nature has made any one thing less susceptible than all others of 
exclusive property, it is the action of the thinking power called an idea, 
which an individual may exclusively possess as long as he keeps it to 
himself; but the moment it is divulged, it forces itself into the possession 
of every one, and the receiver cannot dispossess himself of it."  -- Thomas 
Jefferson