By cjnelson on

Not sure if this is the correct forum for this question but here goes.

We recently moved our old site (html) to a new Drupal based site. In our old site we had a course database that was built in MS SQL. We would still like to be able to access this ms sql database through our new site. Our new Drupal site is running on IIS6, MYSQL and PHP. We would like the course database to be accessed from a content page. I hope this makes sense.

I am relatively new to Drupal so please understand that I may not be asking the question properly. Thank you.

⋅ Categories: Drupal 5.x

Comments

jscoble’s picture

jscoble commented

You can connect to MS SQL Server via PHP. For detailed information: http://us.php.net/mssql

Since early 2006, Microsoft has been working with Zend on optimizing PHP for IIS because of the popularity of PHP and how slow PHP performs in IIS environments. They released a FastCGI extension for IIS6 and IIS7.

cjnelson’s picture

cjnelson commented

As above, we have an online application that is backended on MS SQL. Users go to our online app. web page and are asked to fill in their email address and we in turn email them a password. They can then return to the site and log in using their email address/assigned password. This information is kept in MS SQL.

We would like to be able to do this using Drupal and MySQL. Is this possible? Or is there another way to do this? We want the user to have the ability to log back in to complete their application in case they are interrupted and are not finished yet. We have tried the WebForms Module and we like some of the capabalities, but it does not offer what we would like. Suggestions? Thank you.