"Physical Database not found"-ERROR in Runtime-Version

[Guest_imported]

Hello!

I've just began to program in VB6 and to use Crystal 8 to generate reports, so please don't laugh, if it is a trivial question.^^

In VB my project runs fine, but after generating the .exe file I tried to run the project on another workstation and the CR-viewer states a "Physical Database not found" Error, when I want to see the report!
I've already included all the .dll & .ocx files.

Please help me!

Thanks

Chun-Wah

 

[CrystalVisualBOracle]

Make sure the other computer has windows set up to see the database. Under Control Panel/ODBC data sources you need to set up the computer to see the database machine. Make sure that's set up correctly. (May need to retreive a DBA to help). Good luck.

CrystalVisualBOracle

 

[Guest_imported]

Thanks! But the Workstation sees the Databaseserver in the intranet and ODBC is configured correctly. Do you exactly know what the error message "Physical Database not found" does mean? We tried different users and it works on three different PCs which all are development stations but our test setup gives us with the exe file the error message!

Please help!

Chun-Wah

 

[StevenK]

If you are trying to access the reports through the CRViewer component you will need to register this DLL (CRViewer.DLL) and similarly with Craxdrt.DLL. If you have all the required database access DLLs on the client machine then the other suggestion would be to ensure that your developed code is passing the correct parameters (server-name, database-name, user-name and password) to the setting of the log-on information for the database tables in the report.
Are you able to access data in the required database from the problem client machine through another channel apart from the Crystal Report ?
Does the client machine have Crystal Reports installed - are you able to open andgenerate data in the report throughusing the CR application itself ?

Steve

 

[Guest_imported]

Thanks for the feedback.

The needed .dll files are included , crystal is not istalled on the client, but it should run without it, or am I wrong?

Also the parameters are correct, the connection is all right.

Chun Wah

 

[StevenK]

If you're using the CRViewer component - do you have the following DLL's registered on the client machine (using REGSVR32) :
CRViewer.DLL
CRaxdrt.DLL.
Regards,
Steve

 

[Guest_imported]

Thanks,
but the DLL's are already registered as I mentioned earlier.

The situation is like this:

In VB my application runs fine and the reports are generated normally.(We tested that on 3 different develop-machines with different users) But after generating the .exe-file the application doesn't generate reports any more on a test workstation. The CR-viewer states the "phys. database not found" err.

I've checked the dll's and the connection, all the log-on parameters are correct. I've even tried different users on the test-machine. I also tried 2 different methods to generate the reports:

- pre-generated reports -> so that I only have to open the report

- RDC -> generating the report at runtime

But both methods returned the same error.


Chun-Wah

 

[StevenK]

Do you also have the database access DLL's on the problem client machine ?
These include DLL's such as p2sodbc.dll, etc (see RunTime.hlp in the Seagate Software folder).
Ensure that you have the full list of DLL's as required for accessing your database type (i.e. SQL Server 7.0).
Steve

 

[manju1234]

Hi Friend,

I am also facing the same problem.. can you just tell me once you got a solution.. I too help you once I know the solution.. since 3 days I am trying with many options still I couldn't find the solution..

Thanks & Regards,
Manjunath

 

[balves]

There are a whole bunch of reasons for "Physical Database Not Found" on the Crystal support site:

Type that exact phrase to Ask Jeeves on:

http://support.crystaldecisions.com/

Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer

 

[HomerJS]

I've asked the people at Seagate about the same problem and here's the information I've collected . . .

1. You MUST use an ODBC connection inside the report. If it doesn’t use an ODBC you can change the report by going into Database – Convert Database Driver… click the check box next to Convert Database Driver on next Refresh, and then selecting p2sodbc.dll or pdsodbc.dll depending on the version of Crystal Reports you have installed.

2. Inside Crystal, go to File – Report Options and uncheck the box next to Use Indexes Or Server For Speed.

3. Insert the following line into the form that has the report viewer: (Dim Report as New CrystalReport1)
Report.Database.Tables.item(1).SetLogOnInfo &quot;<ODBC name>&quot;, &quot;<database>&quot;, &quot;<user id>&quot;, &quot;<password>&quot;

4. Make sure the dll, either p2sodbc.dll or pdsodbc.dll, is included in the install package.


If someone has found an easier way please post it.

 

[Ngolem]

I had this problem when trying to run a report with a Crystal Query as the data Location and option #2 from the above list solved my problem

Jim

 

[courtoisf]

&quot;Use indexes or Server for speed&quot; seems to be a problem in a lot of things. Once quick thing to check is that the p2*.dll set of dll's is present in the Windows System folder. They don't need to be registered, they just need to be there. I collected them into a folder and keep it handy for copying as a quick fix.

 

[Guest_imported]

Chun - Wah,
Have you resolved this problem?
I got the same one.
I installed my product on 3 PC. 2 was run well but 1 gave me the same error message. I'm using crystal report 7