error?

[noielen]

i got an error "Logon failed.
Details: [Database Vendor Code:18456]" ?

at my first report in crystal XI...

please help me out. thanks

[SeanK]

Is this a database error or a Crystal Reports error?

[noielen]

i dn't knw but that error prompt when i run my report...

[SeanK]

i dn't knw but that error prompt when i run my report...

Is your report properly linked to a database table?

[RobDog888]

Did you search for the error message/code in CR?

[noielen]

Is your report properly linked to a database table?

yes, i could even drag other fields.

Did you search for the error message/code in CR?

what do you mean Rob? where am i going to search that?

[Hack]

yes, i could even drag other fields.
what do you mean Rob? where am i going to search that?

Their Help Files.

[RobDog888]

If you dont find it in CR's help file then try their website http://www.businessobjects.com

[noielen]

Their Help Files.

No topics found.

[noielen]

If you dont find it in CR's help file then try their website http://www.businessobjects.com

still not found.

[RobDog888]

I found these 3 links on database vendor doce errors.

http://support.businessobjects.com/s...q3=0&indexq4=0

[Hack]

I found these 3 links on database vendor doce errors.

http://support.businessobjects.com/s...q3=0&indexq4=0

My hat is off to you sir, as you have found precisely 3 more links than I found when I Googled the error message.

All Google turned up were questions nearly identical to this one posted in other forums, but with no answers forthcoming.

[RobDog888]

I used the Advaned search feature on the CR site.

http://support.businessobjects.com/s...lt.asp_wwwjump

Sounds like the seconmd one may have some relevance but also looks like this is an ODBC error? How are you connecting to your report?


Edit: I didnt know you wore a hat Hack. Thanks

[noielen]

How are you connecting to your report?

ADO 2.x, SQL database... i'll check first your link/s.

[noielen]

any idea here please...

[RobDog888]

Does the report open the datasource correctly and display the report ok in CR only?

[noielen]

Thanks Rob, it seems i have passed the error earlier. I have a new error named "Class does not support automation or does not support expected interface." with the following code

Dim Report As New CrystalReport1
 
Private Sub cmdview_Click()
 
Dim i As Integer
Dim StrQry As String
Dim rs As New ADODB.Recordset
 
Screen.MousePointer = vbHourglass
 
'HEADER
StrQry = " SELECT * FROM QUOTATION_HEADER WHERE HQUOTENO = '" & "QN-NCL060028-01" & "' "
rs.Open StrQry, conn, adOpenDynamic, adLockOptimistic
'ERROR HERE
Report.Database.SetDataSource rs
'END ERROR
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
rs.Close
Set rs = Nothing
'HEADER
 
CRViewer1.ReportSource = Report
CRViewer1.Refresh
CRViewer1.ViewReport
Screen.MousePointer = vbDefault

[RobDog888]

Ok, I ran into this error before with ADO and CR. Hopefully its the same issue. What version of MDAC is on your system and is it the same one referenced in CR and VB project? If your exe is compiled on a system with, for ex, 2.7 SP1 and you run it on a system with 2.7 you will get that error.

[noielen]

sorry Rob i forgot where i can find the MDAC version. under regedit-->...Mircrosoft--->?
i'm not running yet exe. i run the app in my pc where i create the app.

[RobDog888]

Hmm, ok. Lets start with identifying the MDAC version. Go to the Microsoft website and download the MDAC Component Checker utility. It will tell you what version you have.

[noielen]

Sir please check... is it ok?

[RobDog888]

This is more accurate

http://www.microsoft.com/downloads/d...displaylang=en