[development] MS SQL support in D7?

[Joel Penner (Volt)]

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 at drupal.org [mailto:development-bounces at drupal.org] On Behalf Of Arancaytar Ilyaran
Sent: Monday, January 05, 2009 5:36 PM
To: development at 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 at gmail.com
AOL:   282026638 / RealArancaytar
URL:   http://ermarian.net