Error "Physical Databasew not found" :-(

Hi out there,

I've created some Crystal Reports in a VB Application. Everything works fine on my comnputer.
The application is installed on several other clients, and on some other machines the reoprts do not work, CR generates an error "Physical Database not found".
On the Crystal Reports homepage several articles are given to solve this poblem, but unfortunately nothing helps.

I've done the foolowing things trying to fix the problem:
- distributing the files given in the knowledgebase with the setup
- Unsetting the "Use indexes for speed" option in the CR object
- Setting the "discard saved data" option in the CR Object

Is there any other thing I can do to try to make the CR work?

System-Environment is CR85, database Background is SQL-Server2k, ADO-Version is 2.8"Physical Database not found"

Obviously ur link 2 Db is broken. Did u check SQL client configurations. U should be using ODBC like connection, if u give a direct link to Db in CR, u should expect this problem.|||Hi Janitha,

no it's quite clear that this can't be the problem as the reports are running correctly on some machines. As the database is on sql-Server (and I'm using the sql-Server-driver, no odbc), if the connection would not be initialized correctly the reports would not run on any client.|||Hi out there,

seems that it is a network (and possibly permission of user) problem.
The setup referred to a folder on the intranet of the company, where the app was located. When I changed the link in the setup back to a local installation, everything works :-)

Error "Physical Database Not found" When Loading Report

Hi, i'm using CR 8.5, vb6, using acces 2000, data environment and win xp.
i have installed my application to another computer, which use win98 and don't have access 2000.
when i'm installing my application i got this error message "craxddrt failed to register" and then i select ignore to continue the installation...
when i run my application and loading report i got this error message "Physical database not found"
my question is
is the first error is causing the second error? or the database path that im using is not right?
i already tried to install seagate crystal report on the computer but when installing it also have the same error, error 1904 failed to register craxddrt.dll..
can somebody help me?Hi
In the Menu, Goto Database-->Verify Database and configure it|||hi, thx btw,
i already select the menu and then verify database, so i select my recordset from my data environment and it is up to date....
and still got the error message, :(|||Goto Database-->Set DataSource Location and configure the DB|||already but still the same, i've installed into 2 computer, the one is with win xp and office 2002 which is success and the second is win 98 with no access application which show this error. but i have installed mdac 2.8 and jet engine 4 sp for win 98 and vb runtime sp5, even seagate crystal report 8.5 it self.,??|||I Already solved it.. thx btw.
some dll files which i included when installing my program is xp/nt version, so it become problems when i'm installing it to win 98..
so then i replace my included dll files xp/nt version with dll files from win 98 version...and it works..:D

Error - Cannot open the datafile

Hi there,

I have written a program that loads a package (SomePackage.dtsx) from the physical drive and executes that. The package does nothing but imports data from a csv file to the Sql server 2005. But I can see that the package is failing continuously. I meant the package.Execute() method is returning a DTSExecResult.Failure. I investigated the Package.Errors property that contains the error collection and found that there are two DTSError objects into the collection.

The first one’s description says that

Cannot open the datafile "D:\SOME.csv".

And the later one’s is

component "SOURCE FLAT FILE COMPONENT" (1) failed the pre-execute phase and returned error code 0xC020200E.

But the most interesting thing is if I execute the package through the Execute package Utility (double clicking onto the SomePackage.dtsx file) ships with Sql server 2005 then it executes fine and works as expected. I have checked the permission of the csv file and it has everyone’s full access.

Can anyone help me on this?

I will appreciate all kind of suggestions.

Thanks

Moim

Hi,

"right click" the "flatfile connection manager"

click on "Edit". there are several properties here that needs to be configured

one of which is the "format".. make sure its "delimited" or something that suits your need.

if it didn't solve your problem try other properties

in this area.

regards,

joey

|||

What is different about when you use your tool vs dtexecui?

Is this the same machine?

Is this the same user running both tools?

|||

Darren,

Basically I can see the only difference is when I am running through the code it is failing and when I am running from the windows explorer it is working.

Nothing more. It is same machine, same user.

Any Idea?

Thanks

Moim

|||

joeydj,

Im afraid, I have created that package programmatically so I dont have a scope to edit that inside the Sql Server BI editor. anyway, I checked out and these properties are set.

Any Idea?

Thanks

Moim

|||Is your file on a mapped drive, by chance?|||

Brammer,

No its on a local drive (drive D: ).

Any other idea?

THanks

Moim

|||

Ok, so same package, same machine, same user, same execution parameters, just a different execution host... does not make much sense.

Try adding logging to the package, something simple like log all warnings and errors to a text file. Any other errors? There must be some difference but that error is not very clear as to what.