Hi Guys,
I'm new to this forum but I was hoping someone could help me out with this frustrating MS Excel query issue we are experiencing. We are going through a PC replacement exercise at work at the moment. Some finance staff are getting new machines others are not. All staff with new PCs can no longer access any existing MS queries or open any new queries that they save. Existing/old PC users have no trouble with any of this.
The error presents itself when we open Excel (on the new PCs) goto the 'Data' menu, select 'Import external data' (the Choose Datasource Window appears), goto 'Queries' tab, select an existing query from the list and click 'Open' then we get the following errors :
Insufficient Connection Information was supplied
Driver's SQLSetConnectAttr failed
we then Click OK then......
asecond error appears which is : Couldn't read this file (Click OK or Help)
We have tried a number of things including opening the queries from the old PCs, copying the SQL statements and creating new queries, saving them and trying to open them up on the new PCs but same error. We also tried installing ASAP utilities which was posted on another forum but it didn't make any difference except for slowing down the complete Excel operation on that PC. I don't want to create more issues. After removing the ASAP utlity it was back as it was before.
On PCs were it works it asks you for the OBDC connection first and my understanding is there are passwords stored in the queries themselves - maybe one of these have changed ? I don't really know.
How/where can you access this configuration in MS Query. Is it possible ? Is it in the registry somewhere ??? Does it have to do with the DSN itself or Excel having some security enhancements. The Finance users are all running Microsoft Office Excel 2003 (11.8169.8172) SP3) part of the MS Office Professional Edition 2003.
Any ideas anyone ????
Thanks,
Dave
Bookmarks