Re: [PHP-WIN] Which ORM tool for Windows with Microsoft SQL Server

Re: [PHP-WIN] Which ORM tool for Windows with Microsoft SQL Server

am 20.04.2009 12:12:39 von Richard Quadling

2009/4/20 Andi Gutmans :
> Btw, in Zend Framework while we based our adapter interface on PDO we all=
ow for adapters which are not based on PDO (via quackable interfaces).
> DB2, Oracle and MySQLi are supported in that way as well as of course man=
y PDO drivers.
> You can easily take one of those native DB adapters and make them work wi=
th the sql server for PHP driver.
> Andi
>
>> -----Original Message-----
>> From: David Sceppa [mailto:David.Sceppa@microsoft.com]
>> Sent: Sunday, April 19, 2009 5:18 PM
>> To: Richard Quadling
>> Cc: php-db@lists.php.net; php-windows@lists.php.net; php-windows-
>> internals@lists.php.net
>> Subject: RE: [PHP-WIN] Which ORM tool for Windows with Microsoft SQL
>> Server 7/2000/2005.
>>
>> Richard,
>>
>> As pointed out on other branches of the thread, PDO_ODBC is currently
>> your best option for accessing SQL Server via PDO and technologies that
>> rely on PDO.  We are investigating producing a PDO driver for SQL
>> Server Driver going forward.
>>
>> David Sceppa
>> Program Manager - Microsoft SQL Server Driver for PHP
>>
>> -----Original Message-----
>> From: Richard Quadling [mailto:rquadling@googlemail.com]
>> Sent: Tuesday, April 14, 2009 7:38 AM
>> To: php-db@lists.php.net; php-windows@lists.php.net; php-windows-
>> internals@lists.php.net
>> Subject: [PHP-WIN] Which ORM tool for Windows with Microsoft SQL Server
>> 7/2000/2005.
>>
>> Hi.
>>
>> I'm trying to find an ORM tool to allow me to talk to Microsoft SQL
>> servers (V7, 2000 and 2005) for Windows.
>>
>> For those that use ORM, what do you use?
>>
>> I've looked at Doctrine (requires php_pdo_mssql which isn't part of
>> the VC9 win32 builds; for the VC6 builds, it requires ntwdblib.dll
>> which is oh so dead).
>>
>> I'm looking into Propel next. This now seems to be using PDO and
>> PDO_MSSQL, so it seems I've got the same problems.
>>
>> Ideally, using the nice shiny Microsoft SQL Server 2005 Driver for PHP
>> from Microsoft (http://www.codeplex.com/SQL2K5PHP) would be nice. But
>> this isn't PDO.
>>
>> Is there anyone capable of getting the Microsoft driver PDO aware?
>>
>> Any help/suggestions would be appreciated.
>>
>> Regards,
>>
>> Richard Quadling.
>>
>> --
>> -----
>> Richard Quadling
>> Zend Certified Engineer :
>> http://zend.com/zce.php?c=3DZEND002498&r=3D213474731
>> "Standing on the shoulders of some very clever giants!"
>>
>> --
>> PHP Windows Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
>

Thank you all for your responses. I'm particularly encouraged to see
the response from David @ Microsoft.

My time for learning about using an ORM is limited, so I'm going to
try out Outlet as this supports an "out of the box" experience (ahem).

Regards,

Richard.


--=20
-----
Richard Quadling
Zend Certified Engineer : http://zend.com/zce.php?c=3DZEND002498&r=3D213474=
731
"Standing on the shoulders of some very clever giants!"

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php