PaulaWright
Programmer
- Apr 29, 2003
- 6
Version 8.5
Client Access ODBC Driver
Connection - iSeries/AS400
System DSN
I have created several reports that do not require me to login with my user id and password as long as I already have a connection established on my computer with the AS400; however, when the users try to open these reports they are prompted for the user id and password with my user id as the default and using a different system name than the one set up through the ODBC although it's the same system. They can open the report using their user ID and password with the different system name.
I see in Article ID c2005115 that it was once considered a problem to not be prompted for the user id and password so they "fixed" it. Now I'm trying to find a way to avoid it.
I can see when looking at the Set Location window within the report that my User Id is set - I assume through the Operations Navigator. Is there a way to remove the stored User ID?
How can I fix it so that if a user is ALREADY SIGNED ON to the AS400 he/she does not have to sign on to access the report?
The Connection Options under the configuration for the System DSN are set to "Use default user id, prompt as needed". I've tried filling it with the user's ID on their machine and with a blank user id. Operations Navigator Connection Properties does not allow a blank user ID.
Client Access ODBC Driver
Connection - iSeries/AS400
System DSN
I have created several reports that do not require me to login with my user id and password as long as I already have a connection established on my computer with the AS400; however, when the users try to open these reports they are prompted for the user id and password with my user id as the default and using a different system name than the one set up through the ODBC although it's the same system. They can open the report using their user ID and password with the different system name.
I see in Article ID c2005115 that it was once considered a problem to not be prompted for the user id and password so they "fixed" it. Now I'm trying to find a way to avoid it.
I can see when looking at the Set Location window within the report that my User Id is set - I assume through the Operations Navigator. Is there a way to remove the stored User ID?
How can I fix it so that if a user is ALREADY SIGNED ON to the AS400 he/she does not have to sign on to access the report?
The Connection Options under the configuration for the System DSN are set to "Use default user id, prompt as needed". I've tried filling it with the user's ID on their machine and with a blank user id. Operations Navigator Connection Properties does not allow a blank user ID.