Discussion Locked

Crystal Reports in a vb6 package

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We created a vb6 application with several reports in it. We've created the reports with crystal reports 8.0 . We've compiled the application using the package and deployment wizard from VB. When we run the program on some machine's we get an error using the reports : "Physical Database not found". The other connections in VB are working fine, it's just with the reports.
please help

Geysen Eric.

9 replies

by Former member

I don't have an answer just some ideas to check out. It looks like your Crystal Reports forms can not connect to the data source. I'm assuming that you are using real time data and you can not include the database as a file in the application library. I would check that the users have access to the database that Crystal Reports is looking for. Are these users on a different platform? Maybe there is a .dll problem, old OS and new Crystal Reports software. How about a bandwidth problem? Is your network able to handle the data transfer load?

Good luck, hope this helps jiggle the brain cells.

by egeysen

Thanks for helping But the suggestions i've already tested. The problem is really crystal reports. I've registered already the different dll's and my application is running smootly if I just use my vb appl. I got al the data I need so i don't think the user hasn't access to the database

by dushy_ant

This a Usual Problem with crystal reports.

Try This
Start making a crystal report. Use Data Source name as ADO in more Active Data Source Objects . Here Pass on query and get the desired report format.

In vb application Open an ADO recordset of the query u want to See the output for.

Use the property
m_Report.setdatasource = rs '(name of Recordset)

and assign the recordset to the report.

This way You can make your application faster and use ADO to get the desired output.
(Refer Samples of Crystal Report for Further Details).

All the Best.

by miss kitty

HI.
In your vb application, this is the code that should open your Crystal report.
Dim crxDatabaseTable As CRAXDRT.DatabaseTable
Dim crxParameterField As CRAXDRT.ParameterFieldDefinition
Dim crxFormulaField As CRAXDRT.FormulaFieldDefinition
Set Report = crxApplication.OpenReport _
("D:\Program Files\MIcrosoft Visual Studio\VB98\Contract Haulers Report.rpt", 1)
'IF YOU ARE USING THE FRMVIEWER:
frmViewer.Show vbModal

if you are accessing a SQL server database, you may need to look in the control panel. If you are not a systems person, you need to find someone who is to help you.
open the control panel
double click on network
click on the protocols
make sure that they have tcp/ip installed. (usually your odcbc connection to the sql server is setup for tcp/ip).
Good Luck.
Cathy
covcat@riverstonegrp.com

by bill_brower

You don't say which database you are using, but this error has been killing me over the last few days. I am using CR 8.5 with VB6, connecting to SQL Server. I finally found that I had to include the NTWDBLIB.DLL library with my installation package. Now I can connect my reports to SQL Server. Other databases probably require other support files that Seagate Software does not include in its dependency files. For more information, check support.crystaldecisions.com/fix/ask.asp.

This discussion is closed to new replies.