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

VB6 Crystal Reports Logon failed

Hey guys,

I am an intermediate user of VB6 and a beginner to Crystal. I am using the Reports Wizard to connect to my DB via ODBC, it asks for username and password, I enter it and it displays the table. I map the tables and it auto finds the Primary Key and Forign Keys. I chose the columns I want to display and I run the VB6 program. It returns error:

---------------------------
Crystal Report Viewer
---------------------------
Logon failed.
Details: 28000:[Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password [Database Vendor Code: -103 ]
---------------------------
OK  
---------------------------


But the username and password are correct. If they weren't, I would have never been able to see the tables in the first place. Going crazy over here. What am I missing?
0
triphen
Asked:
triphen
  • 5
  • 5
1 Solution
 
mlmccCommented:
What version of Crystal?

What code are you using for the reports?

mlmcc
0
 
triphenAuthor Commented:
CR v11.5

Not sure what you mean by "What code are you using for the reports?" I used the report wizard to build a very simple report.
0
 
mlmccCommented:
For the report to display you need to add code to assign the report to the viewer and assign the logon information and any parameters the report needs.

mlmcc
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
triphenAuthor Commented:
Oh, I didnt know that :)

Can you give me an example of what this code might look like?

Where would it be? Form Load?
0
 
mlmccCommented:
Depends on how the report is requested?
It could be on a form load.
I have also written apps where the code loading the information was subroutine on the form or even code on another form that works on the crViewer

Is there a form with the CRViewer?

Do you have references to crViewer.dll?

mlmcc
0
 
triphenAuthor Commented:
Form Load says this:

Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault

References attached
vb.png
0
 
mlmccCommented:
WHere does the object Report gets its value?

You don't need both CR ActiveX references.  Remove the second one

mlmcc
0
 
triphenAuthor Commented:
WHere does the object Report gets its value?
Good question :) I designed the report on the fly with the Wizard in VB. I havent really given it a "value"

Thanks! I will remove the other reference.
0
 
mlmccCommented:
0
 
triphenAuthor Commented:
Thanks!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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