Physical database not found

[cfriedberg]

I am compiling a VB 6.0 project that contains several Crystal 8.5 reports. It is not an easy job!

The project is being developed on a machine with Windows xp Professional.

I finally got the project to compile. I then created a package to load on a machine with Windows 2000.

I have made sure that the ADO version is 2.5 on the Windows 2000 machine.

I know that I am connected to the data source (SQL Server 2000) because I can executed queries directly from it.

However, when I try to execute a report, I get the message "Physical database not found."

I am out of trouble shooting methods. What can I do?

Carolyn

 

[LV]

There is probably some dependency database DLL missing. This article might help:

http://support.crystaldecisions.com/library/kbase/articles/c2009409.asp

 

[chelseatech]

With CR8.5, I include everything from Windows\Crystal

That should help. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[cfriedberg]

Including everything did not help me. I put the files in the directory \WINNT\Crystal\ and started the computer again. Because that did work, I also put them in the application folder.

I looked at the Runtime.hlp that comes with Crystal 8.5 and the instructions seem to be for SQL Server 6.xx, and we have SQL Server 2000.

Crystal installation should not be such a secret.

Carolyn

 

[LV]

Is there Msvcp60.dll on your development machine (\WINNT\system32\ directory)? Check the client machine and if it's not there then simply copy this dll into the same directory on the client machine. This is a dependency dll and doesn't have t0 be registered. I had the same error (ASP app) while deploying from a Win2K pro machine to Windows advanced server.

 

[rd2h]

I have a similar issue. I can get the message to go away by setting "Use index for speed" to false in vb and the report works. However, when I change the query on the fly (report needs to change depending on area I'm reporting on), the data remains the same (like its cached on client). Setting it back to true causes Physical Database not Found message to come back.

 

[Tailgun]

If your using ODBC then you must manually add this Crystal DLL to your compile -- p2odbc.dll so it will be on the users machine otherwise you get the error you discuss in the post.