+ Reply to Thread
Results 1 to 4 of 4

MS Query error: no such database (Excel 2003)

  1. #1
    Registered User
    Join Date
    11-06-2008
    Location
    NY
    Posts
    3

    MS Query error: no such database (Excel 2003)

    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.)

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    MS Query error: no such database (Excel 2003)

    You may be able to change the referenced database name with
    the free Pivot Play PLUS add-in, located at Debra Dalgleish's website:
    http://www.contextures.com/xlPivotPlayPLUS01.html

    It allows you to view/edit the Data Source and SQL code
    for Pivot Tables and Query Tables that use external data sources.

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    11-06-2008
    Location
    NY
    Posts
    3
    I'll give it a try, thank you!

  4. #4
    Registered User
    Join Date
    11-06-2008
    Location
    NY
    Posts
    3
    Thank you very much. That solved the problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1