Newsgroups: php.doc,php.internals
Path: news.php.net
Xref: news.php.net php.doc:969379950 php.internals:42486
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain pooteeweet.org from 88.198.8.16 cause and error)
Cc: PHP Documentation ML <phpdoc@lists.php.net>,
 PHP Developers Mailing List <internals@lists.php.net>
Message-ID: <672971F0-0368-46AC-9EBC-B447E391DD0D@pooteeweet.org>
To: RQuadling@googlemail.com
In-Reply-To: <10845a340901050652g6c4fb4asedda64b15fc21385@mail.gmail.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v930.3)
Date: Mon, 5 Jan 2009 16:00:35 +0100
References: <10845a340812310211x5e740748xd81161fef04e2747@mail.gmail.com> <B179ABFE-6802-4685-8845-2EC25174C25E@pooteeweet.org> <10845a340901050652g6c4fb4asedda64b15fc21385@mail.gmail.com>
Subject: Re: [PHP-DEV] Differences in VC6 and VC9 Windows builds and MSSQL Driver.
From: mls@pooteeweet.org (Lukas Kahwe Smith)


On 05.01.2009, at 15:52, Richard Quadling wrote:

> 2009/1/5 Lukas Kahwe Smith <mls@pooteeweet.org>:
>>
>> On 31.12.2008, at 11:11, Richard Quadling wrote:
>>
>>> With Microsoft having their own PHP extension for talking to MSSQL
>>> (http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx -
>>> though documented to only support SQL 2005 and 2008, not 7 or 2000),
>>> could this become the standard alternative for php_mssql.dll (though
>>> not PDO as the MS extension is procedural only, leaving ODBC as the
>>> route for older versions?
>>
>>
>> I do not see us adding a new RDBMS specific extension that only  
>> works on one
>> OS (that is not even our main target OS in practice for deployment)  
>> for an
>> RDBMS that is also quite a niche solution for PHP. Actually the  
>> only RDBMS
>> where I am willing to currently consider a new non PDO extension  
>> sqlite.
>>
>> As such I do not think we should consider bundling this extension,  
>> let alone
>> have it replace the php_mssql.dll.
>
> Even though it will most likely be the case that php_mssql.dll will
> not be available for later versions of PHP/CRT/etc.
>
> Or, are you saying that PHP support for MSSQL is via ODBC only (I
> don't know if php_pdo_mssql uses ntwdblib.dll like php_mssql and as
> such suffers in the same way).


What I am saying is that ext/mssql should be kept alive as long as we  
keep the other "native" RDBMS ext around. Even if its not possible to  
keep it alive for this long for whatever reason, users should be  
directed at PDO.

regards,
Lukas Kahwe Smith
mls@pooteeweet.org