VB6 Prompt Errors

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
loopyadcAsked:
Who is Participating?
 
mlmccCommented:
0
 
SpykairCommented:
Do a search on "0x80004005" on this site. There are a couple of threads might help you.

Spykair
0
 
jrmnCommented:
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
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
mlmccCommented:
Can you show the code?

mlmcc
0
 
loopyadcAuthor Commented:
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
 
loopyadcAuthor Commented:
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
 
mlmccCommented:
Glad i could help

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.

All Courses

From novice to tech pro — start learning today.