Physical Database Not Found

[RobDog888]

I am using SQL 2000 and Crystal Reports 8.5 Developer and I
wrote a report that gets an ADO recordset set at runtime. There
is no problem running the query and printing out the report on
my system, but on another users system it gives a "Physical
Database Not Found" error. The app and report are located on a
network share with no security on it.

This is some of the code...

'ADO objects are populated and open.
Set crxApp = New CRAXDRT.Application
Set moReport = New CRAXDRT.Report
 
Set moReport = crxApp.OpenReport(App.Path & "\MyReport.rpt", 1)
moReport.Database.SetDataSource goRs, 3, 1
moReport.DisplayProgressDialog = True
moReport.PrintOut True, 1

I'm at a loss on this one.

Thanks in advance for any help.

[MartinLiss]

This might point you in the right direction.

[RobDog888]

Yes, before I left work I just figured out that it was a dependancy
dll issue. The two links in your link will help me pinpoint the
dependancy problem. I will post tomorrow after I have tryied a
few of these solutions.

Thanks Martin.

Edit: 4000 posts! Getting closer to custom.

[RobDog888]

Update: For the solution, it was in the link where they inform you
that there is a Runtime.hlp file for Crystal that only comes with
the Developer version. In their help file it shows which dlls and
ocxs are necessary for each type of reference you have in your
project and which general CR functions require other dlls. There
are allot of dlls to add, damn. over 5 Mbs of dlls for basic
functionality of connecting to a SQL server and printing out a
report. Then more if you want to export it, display it, or do other
things.

Its working on other systems except Terminal server and I
haven't tested it on XP either.