Crystal Report and RDC

Hi-
I am trying to use crystal report 8, specially the report designer component. Everything goes fine like connection from Crystal report, field selection but when I run the report it shows me a message "ODBC failed to connect 'MICSAdmin' "(SQL databse user name). I don't understand while all the time it gives me the perfect connection except when I run my VB project. Could you tell me any one ...Am i missing anything? It gives me real frustration.

Thanks in advance
Max

[jeffro]

Hi sahmmed,

Are you using the Crystal Report Control? What I did to connect within vb6 was I put a crystal report control on my main form. Then went into the properties of that control and set the reportfilename in the general tab, and went Preview Window and set all the controls I want to have for the report when it was running.

Then I put this code in the main form:

Private Sub mnuReportsfrmPreviewShift_Click()
With CrystalReport9
.Destination = crptToWindow
.DataFiles(0) = "H:\Software Development Projects\Maintenance database\Maintenance Data.mdb" This tells where to look for the database
.ReportFileName = "H:\Software Development Projects\Maintenance database\Summary By Shift.rpt" This tells where to look for the report
.Action = 1
End With
End Sub


I hope this helps. Good Luck!