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.
Comments
Progress
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
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
Grace, Was the source to the
Grace,
Was the source to the C driver noted above ever released?
It hasn't been released yet
It hasn't been released yet but should be coming soon...
now available
http://blogs.msdn.com/b/brian_swan/archive/2011/11/28/the-sql-server-odb...
I don't know if this will
I don't know if this will help you but probably there will be some useful information in it.
http://drupal.org/node/1892310