Solved

Crystal Report designer in VB 6.0

Posted on 2006-07-17
7
498 Views
Last Modified: 2013-11-14
I have a VB app the allows data entry, and an on demand report on that table.

On the system where the app was developed no problem.

Use Package and deployment wizard.  Install on users desktop. Data entry works fine.

When the report is run, I get a logon error???  Used trusted connection in the Crystal Design
0
Comment
Question by:Jeff_Kingston
  • 4
  • 2
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 17127592
What Crystal dlls did you include with the dployment.  VB knows very little about which you need so most aren't included.

Which version and edition of Crystal?

mlmcc
0
 

Author Comment

by:Jeff_Kingston
ID: 17129407
Crystal 9.0  Developer edition

These are the dll's

File3=@keycode.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,$(dllSelfRegister),$(Shared),11/14/02 11:13:22 PM,221184,9.0.0.281
File4=@u2dapp.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/14/02 7:41:52 PM,53248,9.2.0.543
File5=@u2dpost.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),7/12/02 9:33:12 AM,118784,9.2.0.542
File6=@u2ddisk.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),4/14/03 6:33:54 PM,49152,9.2.1.543
File7=@u2fxml.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),8/14/02 7:33:28 PM,233472,9.2.0.557
File8=@u2ftext.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),5/12/03 6:34:18 PM,155648,9.2.1.556
File9=@u2fsepv.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),3/27/03 7:35:16 PM,135168,9.2.1.32
File10=@u2fcr.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),7/12/02 9:31:26 AM,77824,9.2.0.538
File11=@crtslv.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,$(dllSelfRegister),$(Shared),11/14/02 11:11:08 PM,30793,9.2.1.142
File12=@ExportModeller.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,$(dllSelfRegister),$(Shared),3/24/03 7:30:48 PM,495688,9.2.1.559
File13=@crxf_xls.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),4/25/03 12:40:28 PM,462915,9.2.1.662
File14=@crxf_wordw.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/14/02 7:38:54 PM,163897,9.2.0.567
File15=@crxf_rtf.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/14/02 7:38:44 PM,163895,9.2.0.567
File16=@crxf_pdf.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),3/21/03 11:56:26 AM,389175,9.2.1.567
File17=@sacommoncontrols.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,$(DLLSelfRegister),$(Shared),11/14/02 9:58:12 PM,793173,9.2.1.142
File18=@filedialog.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,$(DLLSelfRegister),$(Shared),11/14/02 10:00:06 PM,873028,9.2.1.142
File19=@crdb_dictionary.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/14/02 8:26:20 PM,1433691,9.2.0.82
File20=@p2ixbse.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),6/20/03 1:58:56 AM,270336,8.0.100.1
File21=@CRAnalyzer.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,$(DLLSelfRegister),$(Shared),11/15/02 12:57:14 AM,172102,9.2.2.570
File22=@sscdlg.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),5/3/02 12:56:40 PM,790528,0.4.1.1
File23=@sscrc.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),10/4/02 1:34:42 PM,2498560,0.4.0.7
File24=@sscsdk80.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),9/9/02 3:17:28 PM,1269760,2.3.6.11
File25=@exlate32.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),12/30/02 8:57:51 AM,671801,9.2.1.186
File26=@querybuilder.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),6/11/03 7:50:02 PM,184391,9.2.1.516
File27=@crdb_odbc.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),6/11/03 7:53:30 PM,386636,9.2.1.605
File28=@crdb_dao.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/14/02 7:44:34 PM,217152,9.2.0.493
File29=@crdb_ado.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),5/29/03 1:24:02 AM,376896,9.2.1.529
File30=@crqe.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,$(dllSelfRegister),$(Shared),6/1/03 7:25:58 PM,1552457,9.2.1.610
File31=@Implode.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),12/1/96 7:00:00 PM,18944,1.0.0.1
File32=@u25samp1.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/15/02 1:23:40 AM,24576,9.2.2.15
File33=@u25dts.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/15/02 1:23:06 AM,24576,9.2.2.8
File34=@u252000.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/15/02 1:22:56 AM,24576,9.2.2.7
File35=@u2lfinra.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/15/02 1:23:30 AM,69632,9.2.2.4
File36=@u2lexch.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/15/02 1:23:22 AM,28672,9.2.2.16
File37=@u2ldts.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/15/02 1:23:14 AM,24576,9.2.2.5
File38=@u2lcom.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/15/02 1:22:20 AM,106496,9.2.2.5
File39=@u2l2000.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/15/02 1:22:28 AM,24576,9.2.2.8
File40=@ufmanager.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),7/16/02 2:37:38 PM,225280,9.0.0.1
File41=@crtowords_en.dll,$(CommonFiles)\Crystal Decisions\2.0\bin,,$(Shared),11/15/02 1:23:48 AM,24576,9.2.2.14
File42=@MSVCRT.DLL,$(WinSysPath),,$(Shared),2/17/04 12:00:00 AM,278581,6.0.9782.0
File43=@craxddrt9.dll,$(CommonFiles)\Crystal
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 17134593
I would change craxddrt9 to craxdrt9.  You don't need craxddrt9 unless you are using some of the dlls that require payment.

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:Jeff_Kingston
ID: 17176174
Have uninstalled the app rebuilt the Package from the ground up, removing the craxddrt9 from the package but still get the same error.

I have tried to install the app on a server with Crystal installed and now I get error 5003!!!

I am beginning to think that I'm going to have to get InstallShield to install applications correctly.  Apparently the VB packager is pure junk.
I always used installshield at previous sites, but this one doesn't currently own it.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
ID: 17176626
I think you may right.  Microsoft has an upgraded version.  I think it is called WINstall.

http://www.microsoft.com/downloads/details.aspx?FamilyID=889482FC-5F56-4A38-B838-DE776FD4138C&displaylang=en

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 17369453
Glad i could help

mlmcc
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
If you don't know how to downgrade, my instructions below should be helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question