Solved

Crystal Report Viewer Login Failed in End-user's computer using Visual Basic 6

Posted on 2008-06-16
5
4,140 Views
Last Modified: 2013-12-25
I created Crystal Reports 11on Designer in VB6 and connected it to OLE DB(ADO) Provider for SQL Server. I used the Standard Report Creation Wizard to create this report. The reports work fine in my work computer but when I tried opening the report in end-user's computer, there is an error said "Logon Failed. Details [Database Vendor Code:556]. I've been trying to search for this type of error but I never found any answers.

Please help. Thanks.
0
Comment
Question by:willhebert
[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
  • 3
  • 2
5 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 21797646
HOw did you install it on the end user's computer?

Did you include the Crystal dlls or merge modules?

mlmcc
0
 

Author Comment

by:willhebert
ID: 21802712
I never included my merge modules. Do I have to reference merge modules? I think I did install all the crystal dlls so far. How to determine what dlls in crystal report will be included in the package? When during deployment of the package of vb6 it asked for bunch of dlls which we included but I don't know if we are missing one.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 21804653
The merge modules are supposed to eliminate the need to include individual dlls.

Did you include the database dlls for Crystal?

What deployment tool are you using?

mlmcc
0
 

Author Comment

by:willhebert
ID: 21804988
These are the list of dlls:
fssl-1-2-1-1.dll
msvcp71.dll
etc-1-0-12-3.dll
atl71.dll
xerces-c_2_1_0.dll
crlov.dll
ParameterDesigner.dll
prompt.dll
sacommlayer.dll
saxmlserialize.dll
saxserialize.dll
keycode.dll
u2dapp.dll
crtslv.dll
ExportModeller.dll
crxf_xls.dll
crxf_wordw.dll
crxf_rtf.dll
crxf_pdf.dll
sacommoncontrols.dll
filedialog.dll
crdb_dictionary.dll
p2ixbse.dll
CRAnalyzer.dll
chartui.dll
sscsdk80.dll
querybuilder.dll
libOCAHelperw-2-13.dll
ebus-3-3-2-4.dll
cxlibw-2-6.dll
libOCASecurityw-1-6.dll
crdb_odbc.dll
crdb_dao.dll
crdb_ado.dll
crqe.dll
u25samp1.dll
u25dts.dll
u252000.dll
u2lfinra.dll
u2lexch.dll
u2ldts.dll
u2lcom.dll
u2l2000.dll
ufmanager.dll
crtowords_en.dll
mfc71u.dll
msvcr71.dll
cslibu-2-0-0.dll
u2ddisk.dll
u2ftext.dll
u2fcr.dll
implode.dll
craxddrt.dll
GdiPlus.dll
craxdrt.
crviewer.dll
p2sodbc.dll
p2irdao.dll
p2ctdao.dll
p2bdao.dll
p2bbnd.dll
crxlat32.dll
MSVCRT20.DLL
CO2C40EN.DLL
pg32.dll
crpe32.dll
crystl32.ocx
MSCOMCT2.OCX
MSSTDFMT.DLL
MSADODC.OCX
MSCOMCTL.OCX
MSDATLST.OCX
msadomd.dll
MSDERUN.DLL
MSDBRPT.DLL
MSBIND.DLL
EXCEL.EXE
dao360.dll

I don't know what is a database dlls for crystals.
I used Package and Deployment Wizard and select Package.



0
 
LVL 101

Accepted Solution

by:
mlmcc earned 250 total points
ID: 21805013
What database are you using?

What database connection method?

mlmcc
0

Featured Post

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!

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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 Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

717 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