I am trying to run the examples in Chapter 3. The example "viewer_ database" runs but prompts you for login information despite having login information in code.

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
   Dim myReport = New ch3_worldsales_northwind()
   Dim myTableLogonInfos = New CrystalDecisions.Shared.TableLogOnInfos()
   Dim myTableLogonInfo = New CrystalDecisions.Shared.TableLogOnInfo()
   Dim myConnectionInfo = New CrystalDecisions.Shared.ConnectionInfo()
   With myConnectionInfo
     .ServerName = "localhost"
     .DatabaseName = "Northwind"
     .UserID = "sa"
     .Password = ""
   End With

   myTableLogonInfo.ConnectionInfo = myConnectionInfo
   myTableLogonInfo.TableName = "customers"
   myTableLogonInfos.Add(myTableLogonInfo)
   CrystalReportViewer1.LogOnInfo = myTableLogonInfos
   CrystalReportViewer1.ReportSource = myReport
   ch3_worldsales_northwind()
End Sub

Does anybody have a fix for this?

Any help is greatly appreciated.

Are you still having problem with this code?

XUMUSKIEFAN
Wrox Moderator

adding the following line after the with...end with:
MyReport.Database.Tables(0).ApplyLogOnInfo(myTable LogonInfo)

For me that alone did not provide the complete solution. I went to the report that was added to the project (ch3_worldsales_northwind.rpt) and opened it up. Then right click any where on the report, select database, select 'set database location' and pointed it to the copy in c:\program files\microsoft office\office\samples\northwind.mdb and clicked update. I also did a verify database (right click, database, verify database). This is what worked for me. Hope it helps some one else

Please not that there is an error in code (and in the ch3 report...):
The correct line in code is:
myTableLogonInfo.TableName = "Customer"

(correct table name in the ch3_worldsales_northwind.rpt report, even if the real name of the table, in Northwind, is Customers...)

and not
myTableLogonInfo.TableName = "customers"

Please not that you have to use C (Uppercase)