To Jeffery, et al:
Thanks for the help and suggestions re: OLE DB.
I've spent another 30 hours or so debugging VFPOLEDB problems and it is looking a lot like VFPOLEDB has a problem with more than 8 RI links from a single primary key with Delete options set to something other than Ignore. If no more than 8 RI options under Delete are changed from Ignore to Cascade or Restrict, it works, regardless whether or not there is a ninth link. If there are any 9 options for a single RI column changed to either Cascade or Restrict, it fails. I haven't tested Insert or Update RI settings, except that 8 Deletes and 1 Update are OK.
Under the described circumstances, attempting to enumerate the stored Procedures/Functions results in some sort of error. Apparently CR 9 enumerates those procedures whereas CR 8.5 didn't.
At the suggestion of a tech at CR, I downloaded a cool tool for testing connectivity from
http://gpoulose.home.att.net/ This tool lets me view and query the database using VFPOLEDB link just fine until I try to view the list of stored procedures/functions. From then on, anything I do results in an error message.
I've looked at the generated RI code and can't see anything suspicious about adding a ninth RI condition, and it works fine in my application.
Now if I can just figure out how to report this problem to Microsoft and get a reply without paying $250. (I've never received a reply from them when submitting bug reports via their web site!)
Well, back to work on the UFL problem....
...Jim