php-windows Digest 22 Apr 2009 10:38:55 -0000 Issue 3609

Topics (messages 29273 through 29275):

Re: Which ORM tool for Windows with Microsoft SQL Server 7/2000/2005.
        29273 by: Andi Gutmans
        29274 by: Richard Quadling

Can PHP determine if the STDOUT for a CLI script is being redirected?
        29275 by: Richard Quadling

Administrivia:

To subscribe to the digest, e-mail:
        [email protected]

To unsubscribe from the digest, e-mail:
        [email protected]

To post to the list, e-mail:
        [email protected]


----------------------------------------------------------------------
--- Begin Message ---
Btw, in Zend Framework while we based our adapter interface on PDO we allow 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 many PDO 
drivers.
You can easily take one of those native DB adapters and make them work with the 
sql server for PHP driver.
Andi

> -----Original Message-----
> From: David Sceppa [mailto:[email protected]]
> Sent: Sunday, April 19, 2009 5:18 PM
> To: Richard Quadling
> Cc: [email protected]; [email protected]; php-windows-
> [email protected]
> 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:[email protected]]
> Sent: Tuesday, April 14, 2009 7:38 AM
> To: [email protected]; [email protected]; php-windows-
> [email protected]
> 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=ZEND002498&r=213474731
> "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
> 


--- End Message ---
--- Begin Message ---
2009/4/20 Andi Gutmans <[email protected]>:
> Btw, in Zend Framework while we based our adapter interface on PDO we allow 
> 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 many 
> PDO drivers.
> You can easily take one of those native DB adapters and make them work with 
> the sql server for PHP driver.
> Andi
>
>> -----Original Message-----
>> From: David Sceppa [mailto:[email protected]]
>> Sent: Sunday, April 19, 2009 5:18 PM
>> To: Richard Quadling
>> Cc: [email protected]; [email protected]; php-windows-
>> [email protected]
>> 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:[email protected]]
>> Sent: Tuesday, April 14, 2009 7:38 AM
>> To: [email protected]; [email protected]; php-windows-
>> [email protected]
>> 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=ZEND002498&r=213474731
>> "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.


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

--- End Message ---
--- Begin Message ---
Hi.

Is there a simple way for a CLI based PHP script to determine if its
output is being redirected to a file or piped through a filter (find,
sort, etc.)

I'm using ANSI escape sequences to colour the output (all working very
nicely), but I want to suppress the codes if the output is being
filtered or redirected to a file.

I've been told about the posix_isatty() function, but as Windows is
not POSIX, I'm looking for a windows mechanism.

I've tried stream_get_meta_data(STDOUT), but it doesn't provide
anything different when used with > or with |.

Any other ideas?

Regards,

Richard Quadling.

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

--- End Message ---

Reply via email to