This error is related to calling a Crystal report from Microsoft access Form. Crystal report is version 8.5 and I've full installation on my PC. Crystal report is calling a stored procedure inside it. We are using SQL Server 2000.
In the Access form when a call is made to launch crystal reports(.action=1) it throws and error "Error 205999: Cannont open sql server). The report works fine in preview mode as well as I'm able to launch a simple crystal report(without db reference) from access code.
I've tried going to some websites but couldn't get a clear solution.
I'd appreciate any pointers.
Thanks
Naveen