I have an ODBC connection showing in the System DNS window of the ODBC Data Source Administrator. I made this connection a few months ago and it has been working fine.
This afternoon I was in my ms access program and tried to link a db2 table but got a connection error. I went back to the connection - went to the Data Source tab & clicked on the Connect button to test the connection.
After a while it came back with a message "Connection tested successfully."
When I go to try to link a db2 table in my access database - I go to - External Data - ODBC Database - link table - Machine Data Source - click on my connection - I get ODBC -- call failed - attached error message.
My connection was working fine this morning - was able to run some queries. Also each time I click on the test connection button it says I connect successfully.