If you have just modified connection cache properties, refresh the cache before you test it.
To refresh the cache:
Highlight the Connection Caches folder.
Highlight the cache’s icon and choose File | Refresh.
Refreshing a cache may affect running components that are using the cache, specifically:
If you change the connectivity library setting, cache references held by components become invalid. Attempts to retrieve connections or query cache properties will cause errors. In this case, the component must retrieve a new cache handle.
If you change other properties, such as user name, password, server name, or the number of connections in a cache, cache references remain valid, but components may be affected by the changed settings. For example, if you change the server name, connections retrieved after the cache has been refreshed will go to the server indicated by the new name.
