Solved

Crystal Report designer in VB 6.0

Posted on 2006-07-17
7
505 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 101

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 101

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 101

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 101

Expert Comment

by:mlmcc
ID: 17369453
Glad i could help

mlmcc
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

696 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