Physical Database not Found

[JCooL]

Hi there...

I have installed a program in windowsXP and when i try to generate the reports show me the error "Physical Data...",
i installed Crystal Report in that computer but it continuous show the error, in the development computer i have WindowsXP, but when i install the program on Win2k PC show the reports without any error.

Im Use
RDC Reports
Crystal 8.5
VB 6.0
Data Access 2.7

I hope your help,

Thank you by Advance

 

[synapsevampire]

You omitted to mention the type of connectivity you use, which is what the error seems to be related to.

Did you set up an ODBC (if required)?

Does this user have rights to whatever database you're using?

Pursue the connectivity aspect.

-k

 

[JCooL]

Sorry!

I use SQL server 2000, and i created a user with all rights.

 

[Hutchine]

I am having the same problem using VB6. The menu has 4 crystal reports, three works fine the 4th gives me the Physical Database not found. All reports use the same table and database on a sqlserver using ODBC.
Thanks
Ed

 

[StevenK]

I'm pretty sure that I've seen the 'Physical Database Not Found' message along the way within development cycles.
The problem was either down to the client machine not having the required access to the database tables being accessed by the report(s) or by the fact that the database tables as used in the report were not being given enough logon information to access the data.
1. Ensure that the client machine can see the database table(s) as used within the report (and any subreports contained therein)
2. Ensure that the client machine has the required database access dll's on it that are required to access the database (i.e. p2ssql.dll, p2sodbc.dll for example if using SQL Server / ODBC).
3. Ensure that you are passing enough information to the database tables (location and login information) as used within the report (and contained subreports).

I'm sorry I can't recall the exact problem we were having with this - or the practised solution but I think the above points may be valid.

We set up Crystal Reports from within a Delphi application against SQL Server database(s) and need to do this dynamically in the sense that we could be reviewing data on any server, in any database in a set of given table names. For this reason we needed to set the location of each used table (using 'CRReport.Database.Tables[1].Location := 'Database1.Table1' within Delphi syntax) and the appropriate login information (i.e. server-name, database-name, user-name and password)

I hope something in the above comments prompts you to find the solution or someone else to throw in their comments and provide the answer to this.

Regards,
Steve

 

[Hutchine]

Try to change your ODBC setup. This worked for me. I deleted the old connection setup and made a new one.

Ed

 

[Hutchine]

Go into the crystal report and set the path of the table you use. The path you use on the development computer may not be the same as the user computer.