[development] ASP Integration with Drupal?
larry at garfieldtech.com
Thu Aug 16 02:04:27 UTC 2007
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
More information about the development