i tried to query from different databases excel sheet 2007 and oracle 11g R1 as shown in the attached screenshot appear error message as shown also in the second attached file...can you help?
i aslo want to know if toad data analyst support SQl and PL/SQL or support SQL langauge only?
Usually the connection to Oracle 11G requires that you use the Oracle ODBC driver. We use the Mircrosoft ODBC driver by default. I assume you have an Oracle client installed? If so go to your Oracle connection properties and on the advanced tab choose the Oracle ODBC driver from the drop down and retry. Use a new Query builder and buidl the query again.
Debbie