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@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