i have a vb6 program load few crystal reports that get data from SQL Server through ODBC...
most of them can load data successfully and printed out...
but 1 of them is using 2 tables and it is fail to load the datas...
it get error...
(Logon failed.
Details:28000:[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user "LOS")
Set Report13 = objCrystal.OpenReport(App.Path & "\Report13.rpt")
CRViewer91.ReportSource = Report13
CRViewer91.ViewReport
CRViewer91.Refresh

what is the problem of this??? because only this report call 2 tables and cannot be loaded.