SQL Server Connection

[Lambro]

When I go to view my report using Crystal Reports 8.5 and using a SQL 2000 database, I always have a message box pop up where I have to select Trusted Connection before I can view the report. Is there a way for Crystal to bypass this and just automatically log into the SQL database? The reason I'm asking is when I try to use the web reporting, it tells me: Error Occurred Reading Records: Server has not yet been opened. This is because Crystal's no logging into the database.

 

[FVTrainer]

Do you want to use a trusted connection? Are you using ODBC, the native driver, or another connection method?

 

[venkatags]

Lambro,

When I go to view my report using Crystal Reports 8.5 and using a SQL 2000 database, I always have a message box pop up where I have to select Trusted Connection before I can view the report. Is there a way for Crystal to bypass this and just automatically log into the SQL database? The reason I'm asking is when I try to use the web reporting, it tells me: Error Occurred Reading Records: Server has not yet been opened. This is because Crystal's no logging into the database

Did you get it work? I am facing the same problem. Could you pass me the solution with code? I want to use ODBC.

Thanks..