Crystal Reports - Trusted Connection

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?

:confused: Is something like this...

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

*bump* :o

Hi
I have been using the Sqlserver2000. I used the code as follows.

Set oCrystalReport = oCrystalApp.OpenReport(sReportFileName)

Code:

---

set crtable = oCrystalReport.Database.Tables.Item(1)
crtable.SetLogonInfo CStr(servername), cstr(dbName) , cstr(uid), cstr(pwd)
set crtable=nothing

---

Here Item(1) represents the Table If you have 2 tables in your report u need to write twise in the above code with Tables.Item(2)

I was doing it that way, but I don't want to give a username/password :o

Bonker,

did you get an answer? I have to port a legacy VB6 system that uses Crystal 6 to windows authentication. Can you help with some advise?