?
Solved

VB6 Prompt Errors

Posted on 2005-04-07
7
Medium Priority
?
543 Views
Last Modified: 2008-02-01
Hi everyone,

I've been evaluating CR-11 for about 3 weeks now and come to a grinding halt!  The report has just about been completed so I want to put it into my VB frontend, but I can't get around the errors.

The 2 errors I get are:
-Prompting failed with the following error message: " Error source: Error code: 0x80004005
and
-Logon failed.  Details [Database Vendor Code: 18456

I successfully compiled a report a few weeks ago in VB with prompts.  But the problem seems to come in when I introduced the dynamic prompts - Is there a way that VB6.0 can cope with this by adding references or something?

I've now removed the dynamic prompts but I still can't get it to work.  Any suggestions?

Thanks again;)

Chris
0
Comment
Question by:loopyadc
7 Comments
 
LVL 10

Expert Comment

by:Spykair
ID: 13724971
Do a search on "0x80004005" on this site. There are a couple of threads might help you.

Spykair
0
 
LVL 4

Assisted Solution

by:jrmn
jrmn earned 200 total points
ID: 13726115
Hi loopyadc,

I found this link (from BO Forum) that talks about this particular error.
Kindly take a look at this...maybe it can help you one way or the other.

http://support.businessobjects.com/forums/message.asp?fid=76&sk=5&ps=25&pn=1&mid=133803



goodluck,

jrmn
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 13726473
Can you show the code?

mlmcc
0
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

 

Author Comment

by:loopyadc
ID: 13726982
Hi mlmcc,

I haven't written any code in my VB app.

I noticed that in the VB app I got to work the CR-11 report was using saved data (so probably wasn't actually querying the db).

I had assumed that when I ran the report in CR developer and had entered the sql db user name and pw that it had been saved and would use the same ODBC connection in the VB app.  Now in the VB app I am not prompted for a user name and pw.  Are there any properties I should set with the Username and Password?

I have used the ODBC and Query Test Utility and my ODBC connection is fine there, but I'm not sure how to define this in the VB app.
Do I just use a normal ODBC connection?  How do I get CR Viewer to use that connection?

Many thanks
Chris
0
 

Author Comment

by:loopyadc
ID: 13728201
I found this code to use with an earlier version - I do want to use the same ODBC that I had specified in the report.
There are no crpctrlPrint object in the CR11 library I'm using for the viewer control.

Am I on the right track?


crpctrlPrint.Connect = "DSN=" & gsDSName & ";" & gsConnectionString   'your connection details
   
crpctrlPrint.ReportFileName = "Report.rpt"  'your report

crpctrlPrint.PrintReport

crpctrlPrint.ReportFileName = ""




Thanks
Chris
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 800 total points
ID: 13732553
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 13781664
Glad i could help

mlmcc
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

864 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