>The error I get is as follows -
>OLE Dispatch exception code 0 from Crystal Report
>Cannot Open SQL Server

I remember seeing this error message couple of years ago. What was weird about it was that only FOX2X tables were in use for this report and SQL Server wasn't in use at all.

I vaguely remember that p2sodbc.dll wasn't the right version. Anyway, I'd check all of the required dll's:

under WinNT\Crystal\*.*
WinNT\System32\p2*.dll
WinNT\System32\Crystl32.ocx
WinNT\System32\Crpe32.dll
WinNT\System32\CrPe32.pdb

This is of the top of my head. There could be more.

HTH,

Sasha

>I put the Crystal Reports 8 ActiveX control on my VFP form. It partially works. I get an error that I cannot decipher that occurs after I run my VFP form and pass parameters to the Crystal Report and start running the Crystal Report using the ActiveX control.
>
>The error I get is as follows -
>OLE Dispatch exception code 0 from Crystal Report
>Cannot Open SQL Server
>
>Does this mean I am missing a .OCX or .DLL file or what is wrong?
>
>I never make it to the preview of the Crystal Report before the error appears. It's almost as if the error happens shortly after I press the OK button after seeing the parameters appear in the Crystal Reports window and after it starts doing the record selection process inside of Crystal.