Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Question Unanswered: Refresh Data Errors

    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.

    Refresh Data....

    [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

    [Microsoft][ODBC Driver for Oracle] Invalid connection string attribute

  2. #2
    Join Date
    Apr 2006
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts