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
