Re: ODBC error in 4.0.0 not in RC2

This is a problem with the implementation of SQLError() in some ODBC drivers / CLI libs. According to the spec, SQLError() should return SQL_NO_DATA_FOUND when it has reached the end of the error stack, but some (most?) do not - thus leading to an endless loop. I have turned this off with adabas but maybe we should generally turn this off. Any chance to get this into the release? -Andreas "Gustafson, Mårten" wrote: > > Yes. I just built both RC2 and 4.0.0 with the same config line. Testing the > same script between the builds. > > > -----Original Message----- > > From: Andi Gutmans [mailto:andi@zend.com] > > Sent: Saturday, May 20, 2000 9:46 PM > > To: "Gustafson, Mårten"; 'php-dev@lists.php.net' > > Cc: 'zeev@zend.com' > > Subject: RE: [PHP-DEV] ODBC error in 4.0.0 not in RC2 > > > > > > I don't think anything has changed in the ODBC code since > > RC2. Are you sure > > you built exactly the same way and with the same options? > > Against the same > > libraries... > > > > Andi > > > > > > At 09:44 PM 5/20/00 +0200, Gustafson, Mårten wrote: > > >It´s the same thing if a user has insufficient privligies on a table. > > > > > >--Marten > > > > > > > -----Original Message----- > > > > From: "Gustafson, Mårten" [mailto:marten@jerbro.se] > > > > Sent: Saturday, May 20, 2000 8:26 PM > > > > To: 'php-dev@lists.php.net' > > > > Subject: [PHP-DEV] ODBC error in 4.0.0 not in RC2 > > > > > > > > > > > > Hello, installed 4.0.0 eralier today without any > > problems. But then I > > > > misstyped a query to select a column that didn´t exist > > and when I run > > > > ODBCExec PHP gets into an infinite loop. > > > > I downgraded to RC2 and the problem disappeard. > > > > > > > > Code snippet (column a doesn´t exist in table user): > > > > $c = odbc_connect('dummy', 'user', 'pass'); > > > > $query = "SELECT a FROM user WHERE username = 'marten'"; > > > > $q = odbc_exec($c, $query); > > > > odbc_close($c); > > > > > > > > > > > > On RC2 i get: > > > > Warning: SQL error: [DBMaker] invalid column name : a, SQL > > > > state S0022 in > > > > SQLExecDirect in adduser.php on line 5 > > > > Warning: SQL error: , SQL state 00000 in SQLExecDirect in > > > > adduser.php on > > > > line 5 > > > > But on 4.0.0 i get: > > > > Warning: SQL error: [DBMaker] invalid column name : a, SQL > > > > state S0022 in > > > > SQLExecDirect in adduser.php on line 5 > > > > Warning: SQL error: , SQL state 00000 in SQLExecDirect in > > > > adduser.php on > > > > line 5 > > > > Warning: SQL error: , SQL state 00000 in SQLExecDirect in > > > > adduser.php on > > > > line 5 > > > > Warning: SQL error: , SQL state 00000 in SQLExecDirect in > > > > adduser.php on > > > > line 5 > > > > Warning: SQL error: , SQL state 00000 in SQLExecDirect in > > > > adduser.php on > > > > line 5 > > > > ....ans so on untill I kill the httpd process > > > > > > > > > > > > I run Apache 1.3.12 and configure php like this: > > > > ./configure > > > > --disable-debug > > > > --without-gd > > > > --enable-track-vars > > > > --enable-calendar > > > > --enable-sysvsem > > > > --enable-sysvshm > > > > --enable-wddx > > > > --enable-ftp > > > > --with-dbmaker=/home/dbmaker/3.6 > > > > --with-mhash > > > > --with-mcrypt > > > > --enable-inline-optimization > > > > --with-mm > > > > --with-apxs=/usr/local/apache/bin/apxs > > > > > > > > Regards > > > > --Marten > > > >