Solved

Crystal Report designer in VB 6.0

Posted on 2006-07-17
7
492 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

861 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now