I have set up an ODBC connection to a back-end Oracle database. I can manually add the SQL to the script that I need, but when I try and use the Wizard to build a SELECT statement, I do not see the column names as I would expect. See screenshot below. I do not connect as the owner of the view, but as another user who has been granted SELECT privileges on the view by the owner.
Does anyone know where the problem may lie please?