ANYONE.... HELPPPPPP.......PHYSICAL DATABASE NOT FOUND!!!

[ravioli]

I have developed a VB6/CR8 application, and it uses MSACCESS as the database. It works fine on my development machine, but When I install this application on my users computers (I have created the SETUP program using PACKAGE AND DEPLOYMENT TOOL) they are getting this error " PHYSICAL DATABASE NOT FOUND", are there any special DLL's to be installed on my users computers? Your help is greatly appreciated.


Thank you very much in advance.

 

[Tuan3249]

Do u have MDAC installed on the user's machine?

 

[ravioli]

I have included the P2SODBC.dll as stated by crystal reports and I also have included the MDAC_TYPE.EXE in the setup package on my clients mahine and I am still getting the same error "PHYSICAL DATABASE NOT FOUND"

 

[blurred]

make sure the 'control' that binds to the database is not hardcoded in your form, say:
.FileName = "path to your db"

it should be in your code, say
"control".FileName = App.Path + "your db name"

so when u install on user machine, the "control" will be able to find your database.

good luck.

 

[jfrost10]

Hey Ravioli,
Keep us posted on whats happening with this. I have an identical problem (vb6.0 app with CR 8.5), and getting the identical error, but with a remote sql db. Looks like this could be more common of an issue than I thought.

Jack

 

[ravioli]

I am using CRviewer and I have my database fields hardcoded in the report itself....I am not specifying them through the VB6 program this is what I have in my program, is there anything I should add
Dim crRep As Report
Dim cr1 As New CRAXDRT.Application
Set cr1 = New Application
Set crRep = crapp1.OpenReport("\\serv1\report\rept.rpt&quot
crRep.ParameterFields(1).AddCurrentValue dt 'svalue
Form1.CRViewer1.ReportSource = crRep
form1.CRViewer1.ViewReport
form1.Show

Your help is greatly appreciated.

 

[jfrost10]

One thing you may want to try, if you have subreports in your report is to loop through each object in the report, and if you find a subreport assign the database permissions to it as well.

Jack

 

[ravioli]

I am not using any subreports, its just a simple basic report.

 

[jofarrell]

Did you check the path your report looks for for the database? Sometimes it keeps the full path not just the name ... c:\path\reportname .... you have to make sure its just the report name .. I had that happen to a few but I cant remember what the error was and it was migrating from Crystal reports 7 to 8 but may be worth a shot for you to look at.


Joanne

 

[ravioli]

I did check the db path in reports and they look exactly the same on the VB project. Infact I tried installing crystal reports on my clients machine and the report works perfectly fine, so I am pretty sure the problem is something with DLL's But I am not sure what DLL's I am supposed to distribute with Crystal8/VB6/MSaccess application. Can anyone tell, what dlls should be distributed for the VB6/CR8/MSACCESS(dATABASE)....


Thanks For the Help..

 

[reidfl]

Did you setup a ODBC data sources when you created your .rpt? If so, make sure you package the ODBC data source (file Dsn) when you run the PD Wizard. Change the install location to ($CommonFiles\ODBC\Data Source.


Hope this helps

reidfl