I have a notes application that gets information from an AS/400 application. I use the client access ODBC driver to get my information.When I set up the ODBC connection, I use a userid and password from a profile document, to get an automatic login. This works good, only the first time my application tries to connect, I still get a login popup with the default user from the operations navigator.
Any idea how to avoid this popup, so we have a ‘real automatic login’ ?
Subject: Automatic login (client access)
Make sure you’re using a system DSN vs User DSN. Seems like that may have caused this to happen before.
Additionally . . .
Use the following settings on the “Connection Options” dialog from the “General” tab in iSeries DSN:
Default user ID:
“Use iSeries Navigator default”
Signon dialog prompting:
“Prompt for SQLConnect if needed”
Security:
“Use same security as iSeries Navigator connection”
If you’re using LSDO, try setting the SilentMode property of the ODBCConnection object to True.
If you want to avoid DSNs altogether, you can use IBM’s ADO interface from within LotusScript. Although you do have to have the iSeries Access software installed, you don’t have to have a DSN configured on every workstation your code will be executed from. And the ADO interface is fairly easy to use.
hth,
dgg
Subject: Automatic login (client access)
I have a procedure with connection to AS400.
My workaround is to use a notes user WITHOUT password.
It ok for you?
Hope this help.
Good job