I have a bunch of Excel files that link to accounting software (Timberline) via ODBC. We just changed Timberline's database name. When I refresh the data in my spreadsheets, Excel prompts for my login and password (as usual) and after entering, I get the following errors:
1) No Such Database
and then after clicking OK on that error, I get:
2) Driver's SQLSetConnectAttr failed
After clicking OK on this error, it takes me to a "Select Data Source" dialogue box. I select the new database but then get the same error.
Any ideas as to what I'm doing wrong?
Part of the problem is that the old database name no longer exists but I have been unable to point the query to the new database.
I am also unable to edit the query. It takes me through the same steps as above.
(Running Excel 2003 on Windows XP with service pack 2 installed.)
Bookmarks