RE: [PHP-DEV] PHP 4.0 Bug #6645 Updated: Solution to 6572

Diego, I suggest you open a support case with OpenLink at http://www.openlinksw.com/support/suppindx.htm Either way, an ODBC trace will be helpful. Uncomment the "DebugFile" line in your odbc.ini and paste the resulting trace into either this bug report one on OpenLink's site. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers -----Original Message----- From: Diego Trinciarelli [mailto:trinciarelli@antek.it] Sent: Tuesday, February 05, 2002 5:37 AM To: php-dev@lists.php.net Subject: Re: [PHP-DEV] PHP 4.0 Bug #6645 Updated: Solution to 6572 None of the solutions seems to work for me, i cannot open Memo fields. If I try to fetch only the memo field It does not return nothing. Using: PHP 4.1.1(isapi module) , win2000 SP2, Openlink ODBC on Visual FoxPro 6.0 database. ID: 6645 Updated by: torben Reported By: bram@xspace.com Status: Open Bug Type: ODBC related Assigned To: Comments: I've copied this text into the appropriate bug report (#6572). Previous Comments: -------------------------------------------------------------------------- - [2000-09-09 23:41:37] bram@xspace.com That should be SQL_CUR_USE_ODBC without the $. -------------------------------------------------------------------------- - [2000-09-09 23:31:59] bram@xspace.com Bug 6572 claims that MEMO fields cannot be read. Oddly, this also happens in ASP/vbscript, however you can MEMO fields to work correctly with the following: You can get MEMO fields to work. Right now it takes some finesse. #1) You may try adding $SQL_CUR_USE_ODBC #2) You need to use odbc_longreadlen before you use odbc_fetch_row, otherwise it will not read enough characters. #3) As of 4.0.2, making odbc_longread too long may cause PHP to become unstable. #4) You may need to make a query that only returns the MEMO field to read it correctly. Otherwise it sometimes just doesn't work (this is similar in ASP and so is probably a bug with Access or ODBC drivers for it.) Example: $conn = odbc_connect( $DSN, $user, $pw, $SQL_CUR_USE_ODBC ); $result = odbc_exec( $conn, $query ); odbc_longreadlen( $result, 1000000); /* Your odbc_fetch_row, etc, will now work */ -------------------------------------------------------------------------- -