Publishing crystal report looking at Excel database password problem

[twofingers]

I have created an excel spreadsheet. linking through a file dsn is a crystal report. All works fine. When I publish that report on enterprise, all is fine until I try to view it through e portfolio. It asks me for a user logon name and password.
I have tried using a system dsn link.
crystal report and enterprise on one machine, spreadsheet on another.
has anyone any ideas ??

 

[Turkbear]

Hi,
As a starting point, be sure the account that the CE Pageserver is running under has permissions to read the files where the Excel Spreadsheet is..

 

[twofingers]

Thanks for response, have got it working... sort of. by using file dsn odbc and having excel spreadsheet on web server. But accesing through CE locks spreadsheet, even when you log off CE. Suspect its ODBC problem - any ideas !!