• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4173
  • Last Modified:

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

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
willhebert
Asked:
willhebert
  • 3
  • 2
1 Solution
 
mlmccCommented:
HOw did you install it on the end user's computer?

Did you include the Crystal dlls or merge modules?

mlmcc
0
 
willhebertAuthor Commented:
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
 
mlmccCommented:
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
 
willhebertAuthor Commented:
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
 
mlmccCommented:
What database are you using?

What database connection method?

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now