Bug #2938: Intermittent Memo fields with Acces 97

From: arunas@anm.org Operating system: Win NT 4.0 SP 6 PHP version: 3.0.12 PHP Bug Type: ODBC related Bug description: Intermittent Memo fields with Acces 97 Many people have reported problems with Access 97, ODBC and PHP 3.0.12. I had some problems too, and so I carefully set: odbc_longreadlen($ResID, 4096); odbc_binmode($ResID,ODBC_BINMODE_CONVERT); And sometimes it worked... Now I have found something that I can reproduce, it may require my database. The following works (and returns several rows): ############# $ConID = odbc_connect("Icons","","",SQL_CUR_USE_ODBC); $query="SELECT I.Id, I.CommandID , " . " I.Preview as Preview, I.File , Remark " . " from Icon I " . " where I.CommandID = " . $CommandID; $ResID = odbc_exec($ConID, $qury); odbc_longreadlen($ResID, 4096); odbc_binmode($ResID,ODBC_BINMODE_CONVERT); odbc_result_all($ResID); ############# o Id is 32-bit int o CommandID is 32-bit int o Preview is Text(255) o File is Text(200) o Remark is Memo If I change "I.File" to "I.File as IconFile" then it no longer works, that is, Remark doesn't come back, regardless of its position in the string. In fact, odbc_result_all() simply aborts when it gets to the Remark field, only printing out the table header and all the fields in the first row up to Remark. The content of the text and memo fields is so far pretty minimal, things like "Test" and "Hello?". This is PHP running in CGI mode with Apache 1.3.9 and Mod_SSL, although I had simlar problems without SSL, so that certainly makes no difference. Thanks for any light! - Arunas