I'm working on a designing a RDC application with Crystal Reports.

Does anyone know how to run a report which connects to the database (SQL Server 2000) using a trusted connection?

Is something like this...

Set oCrystalReport = oCrystalApp.OpenReport(sReportFileName)
oCrystalReport.Database.LogOnServer "p2ssql.dll", "my-server"