Re: [PDO] Re: PHP + PDO + MSSQL

On 19 October 2010 03:51, Stanley Sufficool <[email protected]> wrote:
> mssql and PDO_DBLIB are equivalent in functionality in releases, so
> either should suffice. Be aware though that PDO_DBLIB does not support
> return parameters from stored procedures, but mssql does (mssql_init,
> mssql_bind).
>
> HOWEVER, only PDO_DBLIB supports very large recordsets in trunk.
>
> For general portability, not including any T-SQL specific code, I
> would use PDO_DBLIB over mssql since this is there I believe the
> database layers *should* be heading.
>
> On Mon, Oct 18, 2010 at 1:23 PM, Scott Baker <[email protected]> wrote:
>> I apologize if this is out of turn, but I'm trying to connect to a MSSQL
>> server via PDO. There isn't a lot of documentation about doing this out
>> there, but most of it seems to do point to using dblib (which you wrote part
>> of?).
>>
>> The PHP.net site has a big warning:
>>
>> "This extension is EXPERIMENTAL. The behaviour of this extension including
>> the names of its functions and any other documentation surrounding this
>> extension may change without notice in a future release of PHP. This
>> extension should be used at your own risk."
>>
>> What's the best way to connect to a MSSQL server with PHP right now?
>> I'm running PHP 5.3.3.
>>

I would definitely go with taking a look at the PDO_Sqlsrv extension
which microsoft is actively working on. You can have some basic
documentation here and some code examples and whatnot:

http://msdn.microsoft.com/en-US/library/cc296172%28v=SQL.90%29.aspx

Hope this helps but this is definitely the most active and supported
PHP driver for sql server at the moment.

-- 
David Coallier