Skip to end of metadata
Go to start of metadata

Zend Framework: Zend_Db_Adapter_Sqlsrv Component Proposal

Proposed Component Name Zend_Db_Adapter_Sqlsrv
Developer Notes http://framework.zend.com/wiki/display/ZFDEV/Zend_Db_Adapter_Sqlsrv
Proposers Juozas Kaziukenas
Rob Allen
Zend Liaison Ralph Schindler
Revision 0.1 - 23 June 2009: Creation of page. (wiki revision: 15)

Table of Contents

1. Overview

Zend_Db_Adapter_Sqlsrv provides a Zend_Db_Adapter that interfaces with the Microsoft SQL Server Driver for PHP

2. References

3. Component Requirements, Constraints, and Acceptance Criteria

4. Dependencies on Other Framework Components

  • Zend_Db_Adapter_Exception
  • Zend_Db_Adapter_Abstract
  • Zend_Db_Statement_Exception
  • Zend_Db_Statement

5. Theory of Operation

The component works just like every Zend_Db_Adapter and is instantiated using Zend_db::factory().

6. Milestones / Tasks

  • Milestone 1: Complete proposal
  • Milestone 2: Working prototype checked into the incubator
  • Milestone 3: Unit tests completed
  • Milestone 4: Initial documentation completed

7. Class Index

  • Zend_Db_Adapter_Sqlsrv_Exception
  • Zend_Db_Adapter_Sqlsrv
  • Zend_Db_Statement_Sqlsrv_Exception
  • Zend_Db_Statement_Sqlsrv

8. Use Cases

9. Class Skeletons

Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.

4 Comments

comments.show.hide

  1. Jul 14, 2009

    Tobias Gies

    Looks like good work. I'm pondering over the name, however - wouldn't ZDA_MsSql or ZDA_Mssql be better names to keep the naming consistent? We already have a ZDA_Pdo_Mssql, after all.

    Best regards,
    Tobias

    1. Jul 14, 2009

      Rob Allen

      It's named after the underlying library prefix which is sqlsrv. Zend_Db_Adapter_Pdo_Mssql does the same. Similar with Zend_Db_Adapter_Mysqli.

      People would assume that Zend_Db_Adapter_Mssql used the old mssql extension, which is obsolete and we really don't want this adapter to be confused with that one!

      Regards,

      Rob...

  2. Aug 05, 2009

    Declan Butler

    I've been using Sql Server driver for PHP a while now but not as part of Zend framework.
    Currently I am starting a new project and have started setting up Zend (MVC).
    I can get the initialisation of the Sqlsrv working but I want to continue to connect to the database using Windows authentication.

    I see in Zend\Db\Adapter\Sqlsrv.php the $connectionInfo array uses UID and PWD which I dont need to supply. I get an "unable to connect" exception as I have left them blank in application.ini

    Am I missing an option to enable me to connect via windows auth?

    Thanks,
    Declan

    1. Aug 05, 2009

      Declan Butler

      I got it working by commenting out UID and PWD in Sqlsrv.php...