Skip to end of metadata
Go to start of metadata

<ac:macro ac:name="unmigrated-inline-wiki-markup"><ac:plain-text-body><![CDATA[]]></ac:plain-text-body></ac:macro>
<ac:macro ac:name="unmigrated-inline-wiki-markup"><ac:plain-text-body><![CDATA[

<ac:macro ac:name="unmigrated-inline-wiki-markup"><ac:plain-text-body><![CDATA[

Zend Framework: Zend_Db_Adapter_Sqlsrv Component Proposal

Proposed Component Name Zend_Db_Adapter_Sqlsrv
Developer Notes
Proposers Juozas Kaziukenas
Rob Allen
Zend Liaison Ralph Schindler
Revision 0.1 - 23 June 2009: Creation of page. (wiki revision: 16)

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



Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
  1. Jul 14, 2009

    <p>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.</p>

    <p>Best regards,<br />

    1. Jul 14, 2009

      <p>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.</p>

      <p>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!</p>



  2. Aug 05, 2009

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

    <p>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</p>

    <p>Am I missing an option to enable me to connect via windows auth?</p>

    <p>Thanks,<br />

    1. Aug 05, 2009

      <p>I got it working by commenting out UID and PWD in Sqlsrv.php...</p>