Client Access - Save password
I have an Access app that logs into the AS/400 daily and runs/transfers some queries. I can check the bypass sign-on and auto-reconnect, but if the server running client access is restarted, I have to re-enter the password for the as/400. Is there somewhere I can hard-code the password so that it doesn't have to be entered?
Thanks,
Jeremy
Thanks,
Jeremy
ASKER
I have a batch file that runs the following command:
RUNQRY APCOBJP/OISINPOP1
Then there is another batch file that runs a .tto file.
All access does is run the batch files and imports the data once it is transferred.
I do have a client access ODBC data source setup.
Does that help?
Jeremy
RUNQRY APCOBJP/OISINPOP1
Then there is another batch file that runs a .tto file.
All access does is run the batch files and imports the data once it is transferred.
I do have a client access ODBC data source setup.
Does that help?
Jeremy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Only the Bypass sign-on is not enough.
If you set the systemvalue QRMTSIGN to *SAMEPRF (using CHGSYSVAL), and Client Access Express to "Bypass Signon". Then
you are able to exit your sessions and sign right back in with the user profile provided in the windows logon box of CAE.
If you set the systemvalue QRMTSIGN to *SAMEPRF (using CHGSYSVAL), and Client Access Express to "Bypass Signon". Then
you are able to exit your sessions and sign right back in with the user profile provided in the windows logon box of CAE.
ASKER
Exiting the sessions is not the problem, it is when the server is rebooted that I have to sign in again.
tliotta, I am leaving until Wednesday, I will check in toe the cwblogon command when I get back.
Thanks,
Jeremy
tliotta, I am leaving until Wednesday, I will check in toe the cwblogon command when I get back.
Thanks,
Jeremy
Hi
top answer tliotta. I have just gave it a try. It could be the way round a lot of the Windows --> AS/400 single sing-on issues.
It could be used in conjunction with the "QIBM_QSY_CHG_PROFILE" exit program to ask a user if they wanted to sync the Windows client access password to the to the newly entered user password.
The as/400 could then issue the relevant commands to the PC to update the password cache.
Dave
top answer tliotta. I have just gave it a try. It could be the way round a lot of the Windows --> AS/400 single sing-on issues.
It could be used in conjunction with the "QIBM_QSY_CHG_PROFILE" exit program to ask a user if they wanted to sync the Windows client access password to the to the newly entered user password.
The as/400 could then issue the relevant commands to the PC to update the password cache.
Dave
Dave:
Though it can certainly be used in that context, I'd only recommend it for simple LANs with limited requirements. The CWBLOGON command can be fed from any "secure" (ummm... "hidden"?) location on the PC/LAN. But for more rigorous requirements, review these iSeries Access APIs:
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzaik/rzaikcommapilist.htm
...especially those related to signon and userid/password. Visual Age for RPG, Visual Basic, Java, C/C++ can use these APIs on the PC. It doesn't take a huge effort to create a decently secure and reliable infrastructure for userid/password management. VA RPG in particular can be very handy for the traditional AS/400 programmer.
Tom
Though it can certainly be used in that context, I'd only recommend it for simple LANs with limited requirements. The CWBLOGON command can be fed from any "secure" (ummm... "hidden"?) location on the PC/LAN. But for more rigorous requirements, review these iSeries Access APIs:
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzaik/rzaikcommapilist.htm
...especially those related to signon and userid/password. Visual Age for RPG, Visual Basic, Java, C/C++ can use these APIs on the PC. It doesn't take a huge effort to create a decently secure and reliable infrastructure for userid/password management. VA RPG in particular can be very handy for the traditional AS/400 programmer.
Tom
ASKER
Thanks tliotta, worked perfect.
Jeremy
Jeremy
are you running ODBC
sodbc="AS400"
Set dbAS400 = wsAS400.OpenDatabase(sODBC
if not then please let me know how you are connecting
Dave