Mark,
There were many changes/fixes in VFP OLE DB provider since VFP8 RTM. I would recomend to get the latest one that comes with VFP9 SP2 and check yourself.
>I'm using the VFP8 OLE DB driver (dated 09/25/2003) to drive a web application. When COLLATE is set "GENERAL", the driver does not work correctly. Often it will incorrectly report no records in a query result.
>
>Problems like this with SET COLLATE have been documented to some degree on MSFT's web site, but I'm not certain how pervasive is the problem, nor if it has been fixed in any subsequent VFP OLEDB drivers (such as SP1 or SP2 of VFP9).
>
>Can anybody share more info on this?
--sb--