Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CE 9 - prompting for DB login for Main Report and Subreport

Status
Not open for further replies.

prfctdrg

Programmer
Jul 7, 2004
1
US
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!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top