Solved

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

Posted on 2008-06-16
5
4,126 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
  • 3
  • 2
5 Comments
 
LVL 100

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 100

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 100

Accepted Solution

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

What database connection method?

mlmcc
0

Featured Post

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

777 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