Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Refresh Errors
Suzanne
Compare the connection strings of the new workbook's querytable with the one that doesn't work. With the working querytable open and active, go to the immediate window (alt-F11 to open the VBE, cntrl-G to show the Immediate Window. Type this ?Sheet1.QueryTables(1).Connection replacing Sheet1 with the proper sheet codename. Then do the same thing with the querytable that doesn't work. Is there any difference in the connection string? If so, it sounds like the database was changed and that screwed up the existing querytable. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Suzanne" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
Refresh existing data when changed in data validation list | New Users to Excel | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming |