server not open error while distributing reports

[unnik]

I am using Crystal reports 8.0(developer edition),VB 6.0 and MS Access.
For report integration i am using the following procedure.

1)first make the .rpt file
2)Add a crviwer to the project to view the report
3)And call the report using following code .
we create 2 objects

Dim crxapplication1 As New CRAXDRT.Application
Dim crxreport1 As CRAXDRT.Report

Set crxreport1 = crxapplication1.OpenReport(App.path & "\reports\rptinvoice.rpt&quot
crxreport1.DiscardSavedData

crxreport1.ReadRecords

CRViewer1.ReportSource = crxreport1
CRViewer1.ViewReport


This is working fine .
But when i distribute the reports in a multiuser environment(I put the database in a server and try to access the reorts from client machines) what happens is that i am getting the error : "server not opened"
and i noticed that the report will work only if the database file is lying in the same path as it was when the original .rpt file was designed . If we change the path of the database after the .rpt file is made the report will not work .This same thing happens when we try to use the reports in a multiuser environment.

But if we do the reports using RDC then every thing is working fine .But our rproject has nearly 52 reports and to my dismay i found that the system gets hanged when we added nearly 20 reports using RDC .Upto 20 reports it is working fine .
Can any one give a solution for this ...

 

[LoaferMan]

We had a similar error on a machine. It may not have the same setup as your situation, but we were able to solve our problem after we discovered that the offending machine had an old version of p2soledb.dll in a Crystal directory. We got the new version of the dll and placed it in Winnt\system32 then renamed the old one p2soledb.old.

The problem then went away. Crystal 8.0 LoaferMan - There is no practice life. This is it. (Billy Crockett)