ID: 41404 Updated by: [EMAIL PROTECTED] Reported By: geniuz at geniuz dot cz -Status: Open +Status: Assigned Bug Type: ODBC related Operating System: XP PHP Version: 5.2.2 -Assigned To: +Assigned To: kaolwsky
Previous Comments: ------------------------------------------------------------------------ [2007-05-15 21:34:24] geniuz at geniuz dot cz Description: ------------ When I select over ODBC from table with any column data type defined as TEXT (detected over odbc_columns function), and I fetch rows, I receive one of following messages or php freeze. I selected more than 100000 rows. When I replaced selected TEXT data type column for any other column ie. STRING data type column (and with more saved datas), all is ok without errors. Well, problem must be with TEXT datatype (LONG columns). Warning: odbc_exec() [function.odbc-exec]: SQL error: Failed to fetch error message, SQL state HY000 in SQLExecDirect in M:\4D\.WebRoot\ctp\eshop\index.php on line 65 Warning: odbc_exec() [function.odbc-exec]: SQL error: [Simba][Simba ODBC Driver]Memory allocation error., SQL state S1001 in SQLExecDirect in M:\4D\.WebRoot\ctp\eshop\index.php on line 65 Reproduce code: --------------- $sql = "SELECT Col1, Col2, Col3 FROM MYTABLE"; $rs=odbc_exec($conn,$sql); while( odbc_fetch_row($rs) ) { $data1 = odbc_result($rs,'Col1'); $data2 = odbc_result($rs,'Col2'); $data3 = odbc_result($rs,'Col3'); } Expected result: ---------------- no sql error Actual result: -------------- sql error ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41404&edit=1