Physical Database Not Found error VB6 and CR 1

[StormbringerX]

VB6-SP5 Win2000, SQL2000, Crystal 8.0.1.0

Hi all,

Judging from the number of times this question has been asked, this isn't an uncommon problem, but I have been through all the threads, tried most of the solutions, and still no luck.

I'm trying to create a software package deployment.

In my application I have one crystal report, created using the crystal designer component in VB6. The report is simply a list of names. One Table in one database. Nothing fancy. I'm also using the Viewer to preview the report.

Regardles of the software used to create the package(I have tried creating this deployment package using the VB Package and Deployment Wizard, Inno, the Free Microsoft Visual Studio Installer, and a registered copy of Wise) I receive the error "Physical Database Not Found" when attempting to run the report. The Viewer comes up, Im allowed to enter my parameters (Beginning Name) but as soon as I hit Ok, the error comes up.

1)I know that the runtime dlls and OCX's are installed and registered. (I went through the Crystal Report Developer Runtime Help and got the list of all required dlls).

2) All of the dependency files are there for the P2smon.dll.

3) I've made certain that the database is NOT being verified at runtime.

4) Ive made certain that the "Use Indexes" property is off in the designer properties.

5) I ran the Microsoft Dependency Walker for all of the dlls that I know about and the dependent files seem to all be there.

6) I attempted to find a list of updated dlls on the CrystalDecisions site (businessobjects.com now) but I can't find anything the least bit useful there anymore.

7) I can install the Crystal Reports software on the target machine and the installed VB application works fine. But that's not a feasible solution in the real world.

I feel like that it HAS to be a dll that's not right. But damned if I can find it. Does anyone know of anything else I can try? If there are several copies of a dll on a machine, is there anyway to know which one is the registered one?

Any help would be SOOOOOO much appreciated.

Thanks
Dave

 

[paulmarr]

Hi Dave,

Dont know if this will help - but it sounds like a DSN problem - are you using a system DSN as opposed to a user dsn?

Are you using the same ODBC driver that was used to develop the report?

Hope this helps

paulmarr

 

[StormbringerX]

Hi paulmarr,

I appreciate the response - yours was the only response I received. And for that a star...

I solved the problem, though I'm not certain exactly what fixed it.

First I removed the Crystal .dsr file from my project.
Then I removed the preview form.
Then I removed all references and components that were attached to Crystal 8.
I saved the project.
I reloaded the project.
Added back all references and components.
Reloaded the .dsr file and preview form.
Saved the project and compiled.

I Reran the Wise installer and it went without a hitch. So, though I'm pretty sure it was a mismatched reference of some sort, I don't know exactly what it was.

 

[robwilliams71]

After hours of pulling my hair out, this worked OK.

Many thanks