Solved

Error - Physical Database not found

Posted on 2003-11-16
3
811 Views
Last Modified: 2010-05-03
Hi,
i created a app in vb and deployed it on another machine and i get the following error

      "Physical Database not found"

I read that i could copy the dll's from the WINDOWS\Crystal folder and register them on the other machine to ensure the dll it needs are present. I did this and am still getting the problem.

Any ideas?
0
Comment
Question by:cossy74
3 Comments
 
LVL 3

Expert Comment

by:NBrownoh
ID: 9761670
did you copy the database needed over too?  If you try and access a non existent DB its probably going to return that error.
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 9762123
That is a Crystal error message. This gives some troubleshooting help:

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

Accepted Solution

by:
VK earned 500 total points
ID: 9762477
Hello,

At the site http://support.crystaldecisions.com/library/kbase/articles/c2009409.asp you can find:


---------------------------------------------------------------------------------------------------------------------------------------------------------
The main cause for this error is missing or out-of-date database DLLs on the client computer.

To find which database DLLs are missing or out-of-date use the following steps:

1) In Crystal Reports go to the 'Database' menu and select 'Set Location'. In the 'Set Location' dialog box, note the type of database listed beside 'Server Type'.

2) Open the Runtime Help File (Runtime.hlp) and under the 'Index' tab search for 'Database Access'. From the list of database connection methods that appear, select your server type and then select the appropriate database.

A list of database runtime files appears. Using this list, ensure that you distribute the appropriate database runtime files to the client computer.
---------------------------------------------------------------------------------------------------------------------------------------------------------

1. When you design a crystal report via Ctrystal Report Designer you have to provide the Report with the structure of a reference database.
2. The reference database is needed for creating the report - not to get data from.
3. If you try to access a database for displaying a report you could get the above error when the reference database is not found.
4. To re-assign the reference database please read the description at http://support.crystaldecisions.com/library/kbase/articles/c2009409.asp


Regards

V.K.

Regards


0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now