Drupal 7 with MSSQL

Events happening in the community are now at Drupal community events on www.drupal.org.

Posted by bg1 on March 5, 2011 at 4:28am

I am trying to use Drupal as a front end for my MSSQL database. My concept is to keep Drupal on Linux/Apache with MySQL but have all the content-type fields on a MSSQL database.

Is this the right group for such discussions? If not, what group would be more appropriate for Drupal/MSSQL discussions.

Ideally, I would like to see some Drupal modules that would make content types transparent to the Drupal side, but behind the scenes would split the data and keep the nodes and related functionality on the Drupal side in MySQL and but the actual content type data on the MSSQL side.

Unfortunately, I am new to the Drupal/PHP/Linux world and as of yet have not succeeded in getting MSSQL drivers to work in PHP under Linux.

Any advice or help would be greatly appreciated.

Categories: MSSQL Driver For Drupal

Comments

Progress

Posted by jasondranedesigns2 on November 21, 2011 at 5:54pm

jasondranedesigns2's picture

BG,

Have you made any progress on this? I too have a situation that calls for that setup. I have a LAMP environment but want the DB for drupal on an enterprise mssql server.

Any leads would be a great help.

Thanks

mssql driver for php on linux

Posted by granola on November 21, 2011 at 6:05pm

granola's picture

hi folks - for the scenario you are describing there is no driver avail for php apps on linux to connect with ms sql server. the following announcement was made not long ago:
http://blogs.msdn.com/b/brian_swan/archive/2011/10/13/microsoft-announce...

but it is a C ODBC driver, so there is no direct way to do this from php right now. You can connect to sql server from drupal via the pdo driver but that would have to be on Windows.

Best,
Grace Francisco
Sr. Business Development Manager, OSS Communities
Microsoft