Better way to access MS SQL Server from PHP

[email protected] ("cfs")
Newsgroups php.db
Message-ID <[email protected]>
Currently using ODBC to connect to MS SQL server 2005.  Profiling shows that 
to fetch many rows requires a cursor based fetch of each record - a round 
trip to SQL server for each. I would like to use some driver/interface from 
PHP to SQL server that would get all rows in one round trip, or at least a 
smaller number of round trips. The native SQL driver for PHP has a problem 
with a limit on the number of characters in a string, so can't use that.

Is there anything better to use?
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.