I have a report that uses one database(DSN) for the Main Report and a second databse (DSN) for the subreport. When running the report, I keep getting prompted for username and password for both databases. The username and password are defined in interactiveviewer.asp. If I run on 8 or 8.5 I do not get prompted for the un/pw.
I have another report that is also accessing 2 different DSN's and it is NOT having this problem. I cannot seem to figure out what the difference is between the 2 reports.
Any help would be GREATLY appreciated!
Thanks!!
I have another report that is also accessing 2 different DSN's and it is NOT having this problem. I cannot seem to figure out what the difference is between the 2 reports.
Any help would be GREATLY appreciated!
Thanks!!