The connection is valid and retrieves queryies and passes the test button. No matter how many times I refresh the tables will no longer be available for viewing and such.
Please specify the full connection string used (replace username, password and hostname/database name with dummy values if needed). Also please check that the user mentioned in the connection string has the access rights required to access database schema info.
I had exactly the same problem. Adding "Schemas=1; " resolved it. I recommend adding it by default to ADO driver parameter list because it is difficult to figure it out in without the prior knowledge.