There is a dblink from Oracle to SQL Server.
Toad complains that some of the tables do not exist and sometimes the dropdown with the available columns does not appear.
Sometimes the error ORA-00904 is returned when tunning the select.
Make sure you enter the schema_name when referencing the SQL server table.
It might be also needed to add the user.
schema_name.table_name;
Also make sure the name of the columns are correct. In fact, it is recommended to select the column name from the Toad dropdown.
