News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Brian Swan's Blog:
MSSQL vs. SQLSRV What's the Difference? (Part 2)
March 12, 2010 @ 09:37:44

Brian Swan has posted the second part of his series looking at the difference between the MSSQL driver and the SQLSRV drivers for connecting to SQL Server databases from PHP (part one can be found here). He gets a bit more detailed in this second post.

I'm aiming to provide a high-level comparison that you might use if you were considering moving to the SQLSRV extension, but I think there is also some interesting information if you are just curious about the differences. [...] In cases where a short note wasn't enough (and there were several of these), I've provided relevant links to topics in the SQLSRV documentation.

He talks about things that one offers that the other doesn't, like prepared statements (sqlsrv) and working with stored procedures (mssql). He also mentions error handlng, persistent connections and scrollable cursors in sqlsrv. Finally he gets into a one-to-one function comparison of the two drivers with the sqlsrv function list coming up a bit short compared to the features of the more recend (and well-supported) mssql driver.

0 comments voice your opinion now!
mssql driver sqlsrv microsoft sqlserver compare


blog comments powered by Disqus

Similar Posts

Rob Allen's Blog: Retrieving a list of databases from SQL Server

Zend: ZendCon 2006 Accouncements - Collaborations with Microsoft, IBM, and the new ZendBox

Derick Rethans: Mongo is dead, long live MongoClient

OurBlogLog.com: Joomla vs Drupal , The Sad Truth

Gergely Hodicska's Blog: What is new in PHP 5.3 - part 3: mysqlnd


Community Events





Don't see your event here?
Let us know!


bugfix zendserver symfony language voicesoftheelephpant package community framework opinion library laravel introduction release api install podcast deployment interview unittest series

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework