After developing a number of reports using VB6 and Crystal Reports 8, we
encountered a problem once we distributed the application. I work for a
company that has many locations across North America. When users at another
location try to run the reports they get a "Physical Database Not Found"
error message. What is confusing us is the reports were created using TTX
files and we're using the DataSource property to assign a recordset at
runtime. All database I/O is done before executing the report. We have a
central Oracle 8.06 database which all users connect to over our WAN.

What is even more confusing is users at the site of development CAN run the
reports. These users don't have access to the development environment,
actually their environment should be identical to all other remote users.
The only common link between the developers and the local users is they are
both assigned the same home file server (Windows NT 4.0 clients) but each
user has a unique "home" path on the server.

Could CR8 be holding onto the server name and when the report is executed
attempting to log in? If it fails, which would be the case of remote users I
suppose, the "Physical Database Not Found" message appears? Looking through
the report source files we don't see any reference to the server name,
although we do see the full path of the TTX file used to create the report.
We already ruled out that it might be looking for the TTX file because even
the local users don't have them and the reports work fine for them. Only the
developers have the TTX files.

Can anyone help??

Thanks
Ken R.

        I've had this error message several times with CR7.  Depending
on what platform you're using, distributing some or all of the p2*.dll
and u2*.dll files might fix it.

        Good luck!
        -jht
--
Jeremy Todd                     Database Programmer        _,/

http://www.ag.uiuc.edu/~toddjh/ College of ACES, UIUC       \_  /   \
Zupfe Boy and Night Owl         (And Kangaroo Aficianado)     \)\ /\.\
=========================================================       //   \\
"M-O-O-N, that spells moon" - Tom Cullen                      ,/'     `\_,

Jeremy,

That was it, the users were missing the P2SMON.DLL file. It's still a
mystery because I did include the file with the distribution kit. I'm not
sure why it wasn't installed, but I feel better knowing what the problem
was, now I can fix it.

Thanks
Ken