LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Data Refresh Errors

Hello:
I have worksheets with a query to an Oracle database.
Every now and then Refresh Data fails, whereas, it was
working before. I don't know what could have changed in
my environment. Now another user, who was able to Refresh
Data, can no longer do so. If I create a new worksheet
with the same DSN and query it works fine. Can anyone
tell me how to prevent this error? Thank you for any
information.

This is the error I receive when I execute Refresh Data.

[Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr
failed
[Microsoft][ODBC driver for Oracle]Invalid connection
string attribute


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create refresh button in worksheet to refresh Pivot Table Data Ron Excel Worksheet Functions 1 October 13th 07 01:20 AM
Excel Throwing Circular Errors When No Errors Exist MDW Excel Worksheet Functions 1 August 10th 06 02:15 PM
Refresh existing data when changed in data validation list problem girl New Users to Excel 1 September 28th 05 10:19 PM
Unresolved Errors in IF Statements - Errors do not show in results Markthepain Excel Worksheet Functions 2 December 3rd 04 08:49 AM
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH Ken Roberts Excel Programming 3 September 11th 03 06:02 AM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"