Hi Ken,
Please refer to thread #
727754.
The OLE DB provider doesn't work due to a problem enumerating stored procedures in a database with a large number of stored procedures. I reported this issue to John Kozoil, and he escalated the issue to Chandra Srinivasan on 1/16. She contacted me and we communicated over a period of about a week as summarized below.
1. John Koziol escalated the issue to her.
2. She contacted me and asked for a copy of my data to investigate.
3. I sent her the dbc containing RI stored procedures.
4. She acknowledged receipt and thanked me. (No further communication)
In addition to Crystal Reports 9, I was able to reproduce the problem using George Poulose's ADO Query Tool.
With the discontinuation of ODBC support for VFP 8, it is important that the OLE DB provider work properly. I have deferred purchasing VFP 8 until this and other known issues are resolved.
Regards,
Jeff