db2 and access

[cougartrace]

Hello all,

I have a situation where I'm using access to connect to DB2 os390 via DB2 Connect. On the OS390 side, I was required to change my password. However, in access I'm getting the error that it doesn't recognize my id or password when I try to link a new table. It doesn't even prompt me for my id or password. Somewhere it has stored my old password. Any ideas?

 

[juliane26]

Probably you are using ODBC.
To set that up you better use the Configuration Assistand if you do not know the command line. I can imagine you stored there your userid and password.
This you find in your Start Menue -> IBM DB2 -> Setup Tools or calling db2ca directly in a dos shell.

The other option to see and set up your ODBC data sources is in Windows in your Administration. It can be executed directly calling odbcad32.exe.

Hope that helps, somewhere there is the information about your passwords etc.

Still: better be careful. Access tends to open up connections etc rather uncontrolled and is not designed as a multi-user application. To ensure consistent results is not trivial, since one Query in Access can result in two or three connections and SQL Queries to your data source. We ODBC-traced it once and it was awful.
So the consumed CPU time on the host might be a lot and if you have to pay for it .....




Juliane