Can't Open FoxPro 6 Database Using Crystal Reports OCX in form

[drosenkranz]

I'm a VB programmer using VFP for a first project. I've had a lot of trouble using the Crystal OCX in my FoxPro forms. Although I fixed it before, something keeps happening with FoxPro's ability to use the OCX. Here's the scenario.

1) I have 6 tested reports that run from Crystal reports just fine.

2) The reports won't run when launched from my FoxPro app but this problem appears to be FoxPro based.

Seagate (Crystal Reports) told me they do have a warning that developers should not change any properties for the OCX except through code- never manually for the control. A couple of months ago, I deleted the control and recreated it on my form as per their innstructions and this had fixed this same problem then. I have also had to pack my databases to relieve this error from stopping my reports.

3) I recently compiled and installed this working FoxPro App but the error has reappeared on the installation machine. It read:

"OLE iDispatch exception code "0" from Crystal Reports. Cannot open SQL Server"

Do you have any information or ideas on why the Crystal OCX behaves so poorly with FoxPro 6.0 or how to fix it? [sig][/sig]

 

[TomasDill]

AFAIK Crystal reports OCX by default works throug SQL connection using ODBC. You need to change this in properties in <i>design-time</i> to do not get this error. [sig]<p>Vlad Grynchyshyn<br><a href=mailto:vgryn@softserve.lviv.ua>vgryn@softserve.lviv.ua</a><br>[/sig]