I have several worksheets with a query to an Oracle database. For some reason, the worksheets will fail, that is Refresh Data results in the error message listed below. If I create a new worksheet and use the same DSN and query, Refresh Data works fine. Does anyone know why I am receiving these errors? I now have another user, who was previously able to refresh her worksheets and is now receiving the error. Thank you for any information.
I had the same problem. Our administrator change the ODBC driver to the Microsoft ODBC driver for oracle from the oracle for oracle ODBC driver. Changing it back to the oracle for oracle driver fixes the problem.
MY problem is that now my queries will not work. Rather than taking a week to re-create the queries to my Excel spreadsheets, I would like to know how to convert my MS queries so that they can use the new driver without having to re-write them. Can anyone help?