Bug #52658 [Com]: odbc_fetch_row doesn't fetch memo field

Edit report at https://bugs.php.net/bug.php?id=52658&edit=1 ID: 52658 Comment by: isellountos at netintegration dot net Reported by: cyoung at gcs dot neric dot org Summary: odbc_fetch_row doesn't fetch memo field Status: Open Type: Bug Package: ODBC related Operating System: Windows Sever 2008 PHP Version: 5.3.3 Block user comment: N Private report: N New Comment: The suggested solution: $cnx = odbc_connect('$databaseName', 'user', 'pass', SQL_CUR_USE_ODBC); worked for me. PHP Version 5.3.8 Windows 2003 Server (yeah, still using that) IIS 6.0 Thank you. Previous Comments: ------------------------------------------------------------------------ [2012-02-15 17:55:44] rasmus@php.net Right, so in your case you probably should stick to stuff from proprietary software vendors. Our goal has never been to dislodge anybody. Our goal is to build a tool that works for us. If you want to use it as well, go for it, if not, no problem. ------------------------------------------------------------------------ [2012-02-15 17:42:33] phil at mair dot com "You need to understand that Open Source isn't simply a new vendor that replaces your old proprietary software vendor. Open Source is a collaborative effort of interested parties" ... I think you hit the nail on the head. "Open Source .. a collaborative effort of interested parties" = group of enthusiasts who meander through developments doing whatever interests them. "proprietary software vendor" = a commercial organisation focused on delivering a stable, viable product. I'm not being funny, but for years we have WANTED to encourage our clients to move to open source, but unfortunately we can't because its 'random'. From time-to-time an organisation has taken the plunge, and us 3rd party suppliers catch the cold. And you are right ... "Sitting on the sidelines yelling aimlessly has absolutely no effect in this scenario" ... but I'm not in the business of writing platforms, I never claimed to be, and I don't aspire to it. What I do want to do is write solutions based on solid foundations. Open Source is still failing to deliver 20 years after it's initial promise cos "enthusiasm" alone won't bring it home. I don't want to sound negative, and I do understand the huge effort and commitment undertaken ... but I call it as I see it. ------------------------------------------------------------------------ [2012-02-15 17:01:02] rasmus@php.net If MS was actually dominant this bug would have been fixed. Only half-serious with that statement. ODBC gets very little use and thus very little attention. It is a fringe extension. A minor bug in a fringe extension can go unfixed for a very long time unless someone comes along and contributes a clean patch for it. You need to understand that Open Source isn't simply a new vendor that replaces your old proprietary software vendor. Open Source is a collaborative effort of interested parties. Sitting on the sidelines yelling aimlessly has absolutely no effect in this scenario. ------------------------------------------------------------------------ [2012-02-15 10:34:51] phil at mair dot com This is unbelievable - Open Source is trying to dislodge MS from it's dominant role. You can't seriously expect to succeed in this objective if a MAJOR BUG ... and this is major to anyone trying to develop and support cross-platform applications ... like this is still "Status Open" and relying on patches 18 months after it was first flagged !! Get real people ! ------------------------------------------------------------------------ [2010-08-22 19:47:34] cyoung at gcs dot neric dot org I was able to find a way to fix this "problem" I was having when using odbc_fetch_row with memo fields. When I connected to the database I used the optional cursor_type parameter. $cnx = odbc_connect('$databaseName', 'user', 'pass', SQL_CUR_USE_ODBC); This seemed to allow odbc_fetch_row to retrieve the memo field successfully. I was getting the error below before inserting the cursor type into odbc_connect. PHP Warning: odbc_result() [<a href='function.odbc-result'>function.odbc-result</a>]: SQL error: [Microsoft][ODBC Microsoft Access Driver]Invalid cursor position; no keyset defined , SQL state S1109 in SQLGetData ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=52658 -- Edit this bug report at https://bugs.php.net/bug.php?id=52658&edit=1