[PHP-DEV] PHP 4.0 Bug #9982: odbc_tables fails without closing previous database

[badams]

From:             [EMAIL PROTECTED]
Operating system: winnt4 sp 6
PHP version:      4.0.4
PHP Bug Type:     ODBC related
Bug description:  odbc_tables fails without closing previous database

If calling odbc_tables in a loop the database connection must be closed before callign 
odbc_tables again. 

Error
Exception: access violation 0xc0000005)

eg

This FAILS
for($i=0; $i<sizeof($dbname); $i++)
{
  $conn = odbc_conn($dbname[$i], $name, $pword);
  $res = odbc_tables($conn);
  $n = 1;
  while( odbc_fetch_row($res, $n))
  {
     ...
  }
}
odbc_close_all( );

Yet this works fine
for($i=0; $i<sizeof($dbname); $i++)
{
  $conn = odbc_conn($dbname[$i], $name, $pword);
  $res = odbc_tables($conn);
  $i = 1;
  while( odbc_fetch_row($res, $i))
  {
     ...
  }
  odbc_close_all( );
}

Thanks in advance...







-- 
Edit Bug report at: http://bugs.php.net/?id=9982&edit=1



-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]