'Refresh Data' on Excel sheet Brings Up AS400 Login PrompWindow

[JohnBates]

Hi ODBC experts !

I created this Excel 97 worksheet which retrieves data from a file on an IBM AS400. I'm using a System ODBC data source (using the Client Access driver).

EVERY time the Refresh Data button is clicked... the user gets a prompt to logon to the AS400..... even if the user is already logged on to the AS400...!? After you log in it then populates the worksheet. But why do we get a login window if we are already logged on?

I don't think this has anything to do with the users permissions because it happens to me (a programmer) as well on this worksheet.

Is there a setting in the System DSN that could casue this? Was I wrong to use a System DSN versus File or USer ?

Thanks for any ideas. John

 

[JohnBates]

... I was able to fix this one myself.

Someone else may have this same problem, so this was my solution:

Change the System DSN (ODBC Data Source)...
-click 'Connection Options'
-in the Signon Information window....
enter a default user ID and check-off the 'Use default user ID' option