Crystal Reports - Trusted Connection

[Bonker Gudd]

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"

[Bonker Gudd]

*bump*

[buddu]

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

Set oCrystalReport = oCrystalApp.OpenReport(sReportFileName)

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)

[Bonker Gudd]

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

[JustForFun]

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?