Hi,I would like to import data from AS/400 by using schedule agent.
I use this method : Call ConnexionDB.ConnectTo(“ODBCNAME”, “LOGIN”, “PWD”) and it works.
But the problem is for the first connection because it request the password to access AS/400 on the first connection.
The next connections are OK.
If I use schedule agent, I don’t want to input password the first time.
Do anyone have some suggestion?
Subject: Schedule agent, ODBC and AS/400
I’m going to make a few assumptions since you don’t give many details and inappropriately list this as “All Releases” and “All Platforms”. First, you are using an ODBCConnection. Second, the server platform is Windows. Third, the ODBC driver you are using is the one from Client Access Express.
Assuming all that is correct, either the login and password you are using are incorrect or it do not have access to the database. As far as I know DB2/400 uses the same set of usernames as OS/400, so the login and password should be those of a user with access to the table you want to read from.
– Charles
Subject: Schedule agent, ODBC and AS/400
If you are using LSXODBC then make a change on the AS/400 itself using the command:
CHGDDMTCPA PWDRQD(*NO)
This will change the DDM TCP/IP attributes on the server.
Check with you’re as/400 administrator first though - there could be some potential security implications.
Subject: Schedule agent, ODBC and AS/400
Did you write username and password ınformations to the ODBC Connection property (in the Advanced Window)?
Subject: RE: Schedule agent, ODBC and AS/400
I just can write the username.There is no field for the password.