Hi all, I found scattered references to people getting drupal running on MS SQL and was wondering if MS SQL would be supported in Drupal 7? Thanks, + Jeremy
O'LEARY Jeremy wrote:
Hi all,
I found scattered references to people getting drupal running on MS SQL and was wondering if MS SQL would be supported in Drupal 7?
Thanks,
+ Jeremy
D7 uses PDO as a database backend, and a PDO driver for MS SQL exists: http://de.php.net/manual/en/ref.pdo-dblib.php . It appears to be experimental right now. You need to download it separately and compile or include it in PHP as an extension. Drupal does not explicitly support it (as it does MySQL and SQLite), but it could work with the generic interface, without taking advantage of special features. -- Arancaytar ---------------------- Nothing beside remains: Round the decay Of that colossal wreck, boundless and bare The lone and level sands stretch far away... ---------------------- PGP: http://ermarian.net/downloads/0x27CA5C74 XMPP: arancaytar.ilyaran@gmail.com AOL: 282026638 / RealArancaytar URL: http://ermarian.net
Arancaytar Ilyaran wrote:
D7 uses PDO as a database backend, and a PDO driver for MS SQL exists: http://de.php.net/manual/en/ref.pdo-dblib.php . It appears to be experimental right now. You need to download it separately and compile or include it in PHP as an extension.
Drupal does not explicitly support it (as it does MySQL and SQLite), but it could work with the generic interface, without taking advantage of special features.
Reading a bit more carefully, I see that DB-LIB is not well supported and not recommended on Windows. You should probably look at the ODBC driver instead, which is included in the standard PHP core (and enabled in Windows installations by default): http://de.php.net/manual/en/ref.pdo-odbc.php -- Arancaytar ---------------------- Nothing beside remains: Round the decay Of that colossal wreck, boundless and bare The lone and level sands stretch far away... ---------------------- PGP: http://ermarian.net/downloads/0x27CA5C74 XMPP: arancaytar.ilyaran@gmail.com AOL: 282026638 / RealArancaytar URL: http://ermarian.net
Or better yet, use the new sqlsrv driver directly from Microsoft. http://blogs.msdn.com/sqlphp/ Internally we've been working on getting 6.2 working and it seems to be stable minus a huge bug where it loses the left side menu when you clear the cache. Wish I could find a good place for help, but at the same time we're unsure about sharing code just yet. Kinda stuck in a rough place. =[ Joel Penner Microsoft's Open Source Technology Center -----Original Message----- From: development-bounces@drupal.org [mailto:development-bounces@drupal.org] On Behalf Of Arancaytar Ilyaran Sent: Monday, January 05, 2009 5:36 PM To: development@drupal.org Subject: Re: [development] MS SQL support in D7? Arancaytar Ilyaran wrote:
D7 uses PDO as a database backend, and a PDO driver for MS SQL exists: http://de.php.net/manual/en/ref.pdo-dblib.php . It appears to be experimental right now. You need to download it separately and compile or include it in PHP as an extension.
Drupal does not explicitly support it (as it does MySQL and SQLite), but it could work with the generic interface, without taking advantage of special features.
Reading a bit more carefully, I see that DB-LIB is not well supported and not recommended on Windows. You should probably look at the ODBC driver instead, which is included in the standard PHP core (and enabled in Windows installations by default): http://de.php.net/manual/en/ref.pdo-odbc.php -- Arancaytar ---------------------- Nothing beside remains: Round the decay Of that colossal wreck, boundless and bare The lone and level sands stretch far away... ---------------------- PGP: http://ermarian.net/downloads/0x27CA5C74 XMPP: arancaytar.ilyaran@gmail.com AOL: 282026638 / RealArancaytar URL: http://ermarian.net
That doesn't appear to be using PDO, so it is largely useless for Drupal 7. We're building all Drupal database drivers on top of PDO. --Larry Garfield On Mon, 12 Jan 2009 12:09:25 -0800, "Joel Penner (Volt)" <a-joelpe@microsoft.com> wrote:
Or better yet, use the new sqlsrv driver directly from Microsoft. http://blogs.msdn.com/sqlphp/
Internally we've been working on getting 6.2 working and it seems to be stable minus a huge bug where it loses the left side menu when you clear the cache. Wish I could find a good place for help, but at the same time we're unsure about sharing code just yet. Kinda stuck in a rough place. =[
Joel Penner Microsoft's Open Source Technology Center
-----Original Message----- From: development-bounces@drupal.org [mailto:development-bounces@drupal.org] On Behalf Of Arancaytar Ilyaran Sent: Monday, January 05, 2009 5:36 PM To: development@drupal.org Subject: Re: [development] MS SQL support in D7?
Arancaytar Ilyaran wrote:
D7 uses PDO as a database backend, and a PDO driver for MS SQL exists: http://de.php.net/manual/en/ref.pdo-dblib.php . It appears to be experimental right now. You need to download it separately and compile or include it in PHP as an extension.
Drupal does not explicitly support it (as it does MySQL and SQLite), but it could work with the generic interface, without taking advantage of special features.
Reading a bit more carefully, I see that DB-LIB is not well supported and not recommended on Windows.
You should probably look at the ODBC driver instead, which is included in the standard PHP core (and enabled in Windows installations by default): http://de.php.net/manual/en/ref.pdo-odbc.php
-- Arancaytar ---------------------- Nothing beside remains: Round the decay Of that colossal wreck, boundless and bare The lone and level sands stretch far away... ---------------------- PGP: http://ermarian.net/downloads/0x27CA5C74 XMPP: arancaytar.ilyaran@gmail.com AOL: 282026638 / RealArancaytar URL: http://ermarian.net
On Mon, Jan 12, 2009 at 9:39 PM, Larry Garfield <larry@garfieldtech.com>wrote:
That doesn't appear to be using PDO, so it is largely useless for Drupal 7. We're building all Drupal database drivers on top of PDO.
I researched a little what can be done with that driver. It's very uneasy, because it internally does some *very* strange stuff with references. So I'm with Crell, we need a proper PDO driver before being able to do anything. Damien Tournoud
participants (5)
-
Arancaytar Ilyaran -
Damien Tournoud -
Joel Penner (Volt) -
Larry Garfield -
O'LEARY Jeremy