Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves. 

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external 
resources such as databases, etc. If the script requires a 
database to demonstrate the issue, please make sure it creates 
all necessary tables, stored procedures etc.

Please avoid embedding huge scripts into the report.

<?php

$charPage = CP_UTF8;
$stringDeConexion = 'Provider=VFPOLEDB.1;Data
Source="\\server\data";Mode=ReadWrite|Share Deny
None;Password="";Collating Sequence=SPANISH;DELETED=False';
$cantRegAfectados = -1;
$consulta = 'SELECT * FROM hugedbf1 x INNER JOIN hugedbf2 y ON
x.Id=y.xId';
$conexion = null;
$rs = null;
$comando = null;
# intenta crear el objeto y conectarse
try {
  $conexion = new COM("ADODB.Connection", null, $charPage);
  $conexion->ConnectionTimeout = 1200;
  $conexion->CommandTimeout = 2400;
  $conexion->Open($stringDeConexion);
}
catch (Exception $e) {
  echo "Error creando conexion OLEDB.<br/><br/>". $e->getMessage();
  exit(1);
} 
# intenta crear un comando
try {
  $comando = new COM("ADODB.Command");
  $comando->CommandType = 1; //adCmdText
  $comando->ActiveConnection = $conexion;
  $comando->CommandText = $consulta;
}
catch (Exception $e) {
  echo "Error creando el comando OLEDB.<br/><br/>". $e->getMessage();
  exit(1);
} 
# intenta ejecutar el comando SQL
try {
  $rs = $comando->Execute($cantRegAfectados);
}
catch (Exception $e) {
  echo "Error ejecutando comando OLEDB.<br/><br/>". $e->getMessage();
  exit(1);
}
# pasa los datos al recordset y libera los recursos
$this->recordset = array();
$j=0;
if ($rs->State!=0) {
  while (!$rs->EOF) {
    for ($i=0; $i<$rs->Fields()->Count; $i++) {
      $this->recordset[$j][$rs[$i]->Name] = $rs[$i]->Value;
    }
    $rs->MoveNext();
    $j++;
  }
  $rs->Close();
}
$conexion->Close();
$rs = null;
$conexion = null;
echo "It's all right!";
return 0;

?>

PD: You will need hugedbf1.dbf and hugedbf2.dbf shared on \\server\data
and the user running apache service need permission from I/O there. Also
you have to have installed the VFP OLEDB drivers.

Well, not sure I can even debug that as I see no way to have the VFP data.

But why do you use COM and ADODB instead of ODBC? ODBC will be way more stable than ADODB through COM.

Ups! Please replace $this->recordset by $recordset (copy/paste error;)

That speed! ODBC is slower, the driver is older and, especially, corrupts the index file (cdx) on deletes

If the odbc driver corrupts vfp index, then you should report a bug to Microsoft. I'm not sure we can fix your issue easily, so pls don't hold your breath :)

If you have an xls file (dbf format) you can save it as DBASE IV file. (without a CDX index associated but functional)

Microsoft no longer provides support for VFP, but the OLEDB driver works fine with PHP 5.2.13 so I guess it's a bug in version 5.3.x

Hi, try to copy libmysql.dll from the php dir into apache root, i.e., 

I have ApacheRoot=D:/Apache
and PHP5 inside D:/PHP5

I've copied
D:/PHP5/libmysql.dll

Into
D:/Apache/

And it works (for me).

php5ts.dll is probably searching for the dll and is unable to find it ... and crashes :-)

Cheers!
Jakub Gemrot

Well I did't quite read the problem ... I see that my problem was a little different ... php5ts.dll crashed every time I've tried to call mysql_connect.

Best, Jakub Gemrot

@jakub dot gemrot at gmail dot com

PHP 5.3+ on windows does not use libmysql.dll anymore.

Is that still an issue with any of the actively supported PHP
versions[1]?

[1] <https://www.php.net/supported-versions.php>

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Re-Opened". Thank you.