gistfile1.php

#!/usr/local/zend/bin/php

<?php
require_once 'Zend/Loader/Autoloader.php';

Zend_Loader_Autoloader::getInstance();

try {

  $db = Zend_Db::factory('Pdo_Mssql', array(
      'host'     => 'host.name.com',
      'username' => 'username',
      'password' => 'password',
      'dbname'   => 'databasename',
      'pdoType'  => 'dblib'
  ));
  
  $startDate = "05/01/2011 12:00:00";
  $endDate   = "06/01/2011 12:00:00";

  $stmt = $db->prepare("EXEC sp_name ?, ?"); 

  $stmt->bindParam(1, $startDate, PDO::PARAM_STR); 
  $stmt->bindParam(2, $endDate, PDO::PARAM_STR); 
  $stmt->execute();

  $rows = $stmt->fetchAll();

  Zend_Debug::dump($rows);
  
  $stmt->closeCursor();

} catch (Zend_Db_Adapter_Exception $e) {
  print $e->__toString();
} catch (PDOException $e) {
  print $e->__toString();
} catch (Zend_Exception $e) {
  print $e->__toString();
}