Reports Can't Find Database 
Author Message
 Reports Can't Find Database

I have a VB6 application that includes several CR8 reports and uses an
Access 97 database.  When the application is installed on a computer other
than the one used to create it, the reports will not print.  If the
Report.RecordSelectionFormula is used, a run-time error is generated
(-2147192191, Physical database not found).  Otherwise, the printer lights
flash a couple of times as though it were going to print, but nothing
happens.  Any ideas on what I need to do?

Additional information:
The database location was set to 'same as report' at design time.  This
resulted in a reference such as tblName!dbName.
I am using a DSN-less MS Jet 4.0 connection. The computers have Mdac 2.5
installed.
The reports work fine when the app is installed in any folder of the
computer used to create the app.
Simple Printer.Print statements work and the app has no data access
problems.



Tue, 15 Jul 2003 12:12:48 GMT  
 Reports Can't Find Database
Don't know if you still need help.  I had the same problem.  Turned out that
crystal needed the P2BDAO.DLL .


Quote:
> I have a VB6 application that includes several CR8 reports and uses an
> Access 97 database.  When the application is installed on a computer other
> than the one used to create it, the reports will not print.  If the
> Report.RecordSelectionFormula is used, a run-time error is generated
> (-2147192191, Physical database not found).  Otherwise, the printer lights
> flash a couple of times as though it were going to print, but nothing
> happens.  Any ideas on what I need to do?

> Additional information:
> The database location was set to 'same as report' at design time.  This
> resulted in a reference such as tblName!dbName.
> I am using a DSN-less MS Jet 4.0 connection. The computers have Mdac 2.5
> installed.
> The reports work fine when the app is installed in any folder of the
> computer used to create the app.
> Simple Printer.Print statements work and the app has no data access
> problems.



Fri, 29 Aug 2003 03:26:14 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. 'Canned' data in VB program

2. Crystal Reports Canned Code

3. 'System Database' property not found

4. 'Help-Find'-style interface for vb4 programmed database search

5. 'Help-Find'-style interface for vb4 programmed database search

6. 'Physical database not found'

7. 'Physical database not found' error message

8. Crystal Report Designer doesn't start in VS.NET (specified module could not be found)

9. Crystal Report can't find the datafile..

10. Can't find Database Wizards/Access 95

11. Please Help, Why VB3 Application Can't Find Database Index

12. Crystal Reports - Unable to find database dll

 

 
Powered by phpBB® Forum Software