Authorization Error when Macro runs to load data from As400

[swaps400]

Hi,

I have one machine where ODBC is set up to connect to AS400.
Upon executing the macro, it gives authorization error. While on the other machine , user is able to run the macro and load data from excel.

Can you please suggest what could cause error? I do not have access to macro as it is password protected and nobody knows password. Apart from this, other users are able to use and load data from as400.

[jamief]

Re: Authorization Error when Macro runs to load data from As400

I would guess the userid's on the two systems are not in sync.

try doing a savsecdta on the working system.
then restoring (RSTUSRPRF) the userid on the not working system.

Now the trouble is what is the password if you cant access the macro
you are in big-o-trouble.

jamie

[tomholden]

Re: Authorization Error when Macro runs to load data from As400

Now the trouble is what is the password if you cant access the macro
you are in big-o-trouble.

jamie

and this is why you should not use macros...jmo

[swaps400]

Re: Authorization Error when Macro runs to load data from As400

and this is why you should not use macros...jmo

Ha ha

Anyways Guys, with trial and error method... I am able to locate the error.

In the ODBC connection, Connection properties state - Use iSeries Navigator default. When we change it to other user profile. It does not work.

It refers to the user profile, which was mentioned in the iseries navigator default.
I just want to know how can we change the sign on properties. FYR I am using PCOM version 5.9 and 5.7

Any help would be appreciated!

Thanks a lot.

[jamief]

Re: Authorization Error when Macro runs to load data from As400

What is the Iseries Navigator default ID ?
what level security does this character have?

[swaps400]

Re: Authorization Error when Macro runs to load data from As400

I did not get your meaning.

I have PCOM configured to access the AS400. So while setting up AS400 configuration I have specified user name to log into system. Attached here screenshot.



I just wanted to know how can we change this default id?

[tomholden]

Re: Authorization Error when Macro runs to load data from As400

just type in the user ID in the little white box...

[swaps400]

Re: Authorization Error when Macro runs to load data from As400

Sorry for confusion... may be i did nt explain my prob neatly.

Once we type in user id in white box... next time whenever we login to AS400, it asks password only with user id box being containing the user id (we specify in the screen above).
I need to change this default user id in order to work my macro. Is there any way to change it.

Also any text file or something which we can edit to make entry for new user id? Did any one face such problem? Not like Macro but like changing the default user id in iseries set up.

Regards,
Swaps

[tomholden]

Re: Authorization Error when Macro runs to load data from As400

it will always prompt using a default user, prompt as needed for the initial login. the only way that I know of to "short-circuit" that behavior is by having the windows user ID & password match the credentials on the as/400(iseries, pick a frigging name) even that is handled by an encrypted "Lan Man" hash on the PC. so basically without that (or possibly Kerebros/single sign-on" ) you're hosed. the only way i've done anything like that is using an FTP script...

[swaps400]

Re: Authorization Error when Macro runs to load data from As400

Ohh... Im also searching for this solution. There must be some way out. I will post it if I find something useful in this regard.