CraigGoldie
Programmer
Hi,
I'm researching a method for creating a report with a File DSN to go along with it (such that any user that opens the report will have database access, regardless of the ODBC sources on their machine). We are using v8.5.
I am hoping to include in the DSN the server and database name, but _not_ a valid userid/password combination. The idea is that each user running the report will log in with their own information and see different things.
I can't seem to figure out how to change the login information easily. Many people will view these reports through the ActiveX web interface, and thus I can try to programatically alter the information through an ASP page, but the samples I have found so far (alter each Report.Database.Table's LogOnInfo) doesn't seem to work.
Any ideas would be extremely helpful.
Thanks,
Craig Goldie
I'm researching a method for creating a report with a File DSN to go along with it (such that any user that opens the report will have database access, regardless of the ODBC sources on their machine). We are using v8.5.
I am hoping to include in the DSN the server and database name, but _not_ a valid userid/password combination. The idea is that each user running the report will log in with their own information and see different things.
I can't seem to figure out how to change the login information easily. Many people will view these reports through the ActiveX web interface, and thus I can try to programatically alter the information through an ASP page, but the samples I have found so far (alter each Report.Database.Table's LogOnInfo) doesn't seem to work.
Any ideas would be extremely helpful.
Thanks,
Craig Goldie