Crystal Report: Failed to open connection

[snufse]

I have an asp application that runs a Crystal Report (pull method). I dont't seem to get past error in my connection. I need the Crystal Report connect to different servers depending upon user selection. The data base and sign on are always the same.

Here is my attempt:

Dim myPath As String = (Server.MapPath("PlantSalesReport.rpt"))

myCrystalReport1.Load(myPath)

myCrystalReport1.SetParameterValue("Ask-Date", DropDownList2.SelectedValue)

CrystalReportViewer1.ReportSource = myCrystalReport1

CrystalReportViewer1.Zoom(100)

CrystalReportViewer1.Width = 500

Dim myLogin As New ConnectionInfo

myLogin.ServerName = "RG5543"

myLogin.DatabaseName = "C:\Program Files\Astec Industries\WM2000\Data\WM2000DATA.add"

myLogin.UserID = "xxxx"

myLogin.Password = "yyyy"

Dim myTables As Tables = myCrystalReport1.Database.Tables

For Each myTable As CrystalDecisions.CrystalReports.Engine.Table In myTables

Dim myTableLogonInfo As TableLogOnInfo = myTable.LogOnInfo

myTableLogonInfo.ConnectionInfo = myLogin

myTable.ApplyLogOnInfo(myTableLogonInfo)

myTable.Location = myTable.LogOnInfo.TableName

Next

Now when I runn the app I get error:

Failed to open the connection. Failed to open the connection. C:\WINDOWS\TEMP\PlantSalesReport {64260EE9-7818-45DC-8D07-381284D2DEB8}.rpt