Drupal, SQL Server and IIS7

Is there a SQL Server Provider for Drupal? I know that there is a SQL Server Client for PHP in beta and I wonder whether it would be hard to change the database provider to point to SQL Server instead of MySQL.

  • TSQL function to find difference between two dates taking weekends and holidays into account
  • SQL Server variable columns name?
  • Copy an existing row “n” number of times in SQL Server
  • Display selected item from datagridcombobox in the next cell which is datagridtextcolumn using vb.net
  • Reusing SqlCommand?
  • Trying to get all xml nodes with SQL Server, what am I doing wrong?
  • PDOException: SQLSTATE
  • How to access data in a separate MS SQL database from within a Drupal site?
  • Drupal 7 webform submission to remote MSSQL server
  • 2 Solutions collect form web for “Drupal, SQL Server and IIS7”

    Drupal core only officially supports MySQL and PostgreSQL as database providers for Drupal 6, with work being done to support SQLite for Drupal 7.

    The best resource I could find was this item (http://drupal.org/node/74308) in the issue queue, but it hasn’t had activity in a few months. There are a few patches posted with database layer files, but you will have to thoroughly test them for your use.

    There were a couple postings on groups.drupal.org about using SQL Server for sites as well that may be worth checking out: http://groups.drupal.org/taxonomy/term/844.

    Drupal 6 does not support SQL Server. Drupal 7’s new database layer will be based on PDO. While PDO doesn’t yet work directly with SQL Server, both PDO and SQL Server work with ODBC. So, in theory, you’ll be able to use SQL Server with Drupal 7. How that works in practice remains to be seen.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.