Physical database not found. 1

[gunner1]

I've developed a report using the Crystal Reports Designer in VB6. I'm able to run my application and view the report, but when I install the application on to another machine on our network and attempt to view the report, I get a 'Physical database not found' message and no report. What can this mean? The user has priveleges to access the database (SQL 7.0). The application works fine on her machine, she can view and change data without a problem. I'm connecting to the database using the OLE DB server.
When I bring up the Set Location dialog box when I'm working in the designer, I see the UserID is 'dob'. What does that mean? Do I need to change that?
Thanks for any help. [sig][/sig]

 

[earme]

You're missing a dll that CR needs. I think it's p2bdao.dll. I don't believe it has to be registered, just put it in the winsys directory. I think that's also where you can find it on your PC.

Hope this helps,
Evie [sig][/sig]

 

[gunner1]

The answer was to copy p2ssql.dll and p2lsql.dll to the client machine. Thanks to earme for pointing me in the right direction. [sig][/sig]

 

[KenRR]

Hey gunner1,

I have a very similar problem. We are using DDF (TTX) files to build our reports and then supply an ADO recordset using the SetDataSource method. We are using a remote Oracle 8 database and VB6 SP4. The reports run on all development machines, and some user machines, but other users get the "Physical Database Not Found" error. We can't find any pattern to it! We've confirmed the recordset has the data the report needs. Since we used TTX files I didn't think it would look for a "physical database"?? Did you find the solution to your problem? Maybe it will help me too.

Thanks
Ken R.
zrt6@hotmail.com

 

[earme]

I'm not familiar with DDF files, but the "Physical Database Not Found" error occurs with the PC is missing a dll that it needs to be able to view the file or manipulate the date, not when it can't actually find the data. Perhaps the erroring PC's are missing an Oracle dll? Or a Crystal Reports dll for Oracle?
I have a couple programs that Seagate Support sent me that allow you to view the dll's that an app is using. Once you have those, you can compare those dll's with the dll's that are loaded on the PC with the error message and include it. However, if it only uses the dll for a very brief period of time, it might not grab it. If you're interested in this, email me at erote@ssinc.com and I'll email them to you.

HTH,
Evie

 

[KenRR]

Yep, that was it. The users were missing the P2SMON.DLL file. It would have been nice if Crystal Reports would have told me that in the error message.

Ken

 

[eang]

you should try with this dll msvcp60.dll that is in VisualBasic 6.0 I deal with the same problem a few days ago...

 

[earme]

Hello,

To those of you I emailed those two programs to, could someone be so kind as to email those back to me. I had to reformat my PC and start from scratch and I forgot to save those programs.

Thanks!
Evie
erote@ssinc.com

 

[Guest_imported]

I also had same problem but I fixed that problem by registering the msvcp60.dll.
It does not automatically include in the package and deployment wizard but you have to include it manully.

Hope so it helps.

Regards
Amandeep Dhindsa

 

[earme]

I no longer have a copy of the programs that I mentioned. But you can download one of them from

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/modules.zip.asp

earme