Re: [PHP-DB] Problem when using SQL_CUR_USE_ODBC on connect

2008-04-02 Thread cfs
age news:[EMAIL PROTECTED] > (This isn't a solution, per se...just a suggestion.) > > I don't know how they compare; I've never personally used the ODBC > functions... > > But, you may give the MSSQL functions a try: > http://php.net/mssql > > - Jon L

[PHP-DB] Problem when using SQL_CUR_USE_ODBC on connect

2008-03-31 Thread cfs
I'm using PHP with Apache. PHP code connects to MS SQL server using ODBC. I'm doing a query against a table that is very simple: one column of the real data type, one of the text data type. The text field is set to "testing 1,2,3". The real column is set to 10.015. When I use the default c

[PHP-DB] Better way to access MS SQL Server from PHP

2008-03-31 Thread cfs
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 le