By scott859 on

I have a client that is on a Microsoft platform, using IIS with a Microsoft SQL Server database. They want to use Drupal in a site they are developing.

I can see a module for Drupal 7 allowing a SQL Server database but nothing on Drupal 6.x. Does anyone know if Drupal 6.x can be used with a SQL Server database?

Thanks for any insight you can provide.

Scott

Comments

DiversiCon’s picture

DiversiCon commented

A Google search revealed the following discussion which is a pretty lengthy discussion of the issue (http://drupal.org/node/74308). It would appear that there is no out-of-the-box solution for MS-SQL connections but it does seem possible.

If you're into writing some code you may like to review this thread (http://social.msdn.microsoft.com/Forums/en-US/sqldriverforphp/thread/705...) and this comment and it's responses (http://drupal.org/node/778792#comment-2894022).

Good Luck!!!

scott859’s picture

scott859 commented

@ DiversiCon,

Thanks so much for the info - very helpful!

Best,

Scott

etothex23’s picture

etothex23 commented

Did you figure out how to do this?

I am not sure where to put the connection string, or how to set it up. Drupal 6.2 installation only tries mySQL. I am not sure how to get it to look for mssql?

settings.php?
includes\xxx.inc?

Does anyone have an answer?

scott859’s picture

scott859 commented

Greetings,

We ended up using MySQL with IIS. There have been some issues but all in all it is working well.

Scott