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

2008-04-02 Thread cfs
The mssql driver uses a dll that has a limitation on varchar fields of 255 characters. And the 30 chracter column name limit. And after SQL 2005, may not be supported at all. So that alt has been tried, and then adandoned. ""Jon L."" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]

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

2008-04-01 Thread Jon L.
(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. On Mon, Mar 31, 2008 at 3:27 PM, cfs <[EMAIL PROTECTED]> wrote: > I'm using PHP with A

[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