Ok I saw the other thread about physical DB not found, but in my case i'm
using SQL server 2000

I do not want to use a DSN, I am using the native SQL connectivity method

I have the following code.

Private crxApplication As New CRAXDRT.Application
Private Report As CRAXDRT.Report

Public Sub SetReport()
  Dim crxDatabaseTable As CRAXDRT.DatabaseTable
  Set Report = crxApplication.OpenReport(App.Path & "\reports\report1.rpt")
  For Each crxDatabaseTable In Report.Database.Tables
    crxDatabaseTable.SetLogOnInfo "ABG_FS04", "Products", "reports",
"numpty"
  Next crxDatabaseTable
End Sub

Private Sub SSCommand_Click()
  CRViewer.ReportSource = Report
  CRViewer.ViewReport
End Sub

Yet I still get the physical db not found on my client machine (developer
machine works fine)

Have followed the KB article..... so what now?

Cheers

Ric Pullen