we are trying to read data from an AS400-System with SELECT-adapter services, but the list under is always empty ( is working). This problem occures in developer and designer under WM7.x and 8.x, but only with AS400 databases.
The libraries-property (other properties) on the connection is set correctly and dynamic-SQL-adapter-services are working fine without specifying a catalog or schema in the statement.
We need to use because the schemas are named differently on test, integration and production environment.
Does anybody know how to fix this?
thanks & greetings