Microsoft KB Archive/270078

= XL2001: Microsoft Query Returns &quot;vsi:ODBC$DriverMgr Could Not Be Found&quot; Error =

Article ID: 270078

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q270078



SYMPTOMS
When you double-click Microsoft Query in the Office folder for Microsoft Office 2001, you receive the following error message

The application &quot;Microsoft Query&quot; could not be opened because &quot;vsi:ODBC$DriverMgr&quot; could not be found.

and Microsoft Query does not run.



CAUSE
This error message occurs because Microsoft Query is looking for Open Database Connectivity (ODBC) components that are not fully installed on the computer.

NOTE: The error message occurs even if you have already installed Microsoft Query from the Office 2001 Value Pack, because the necessary ODBC components are not included in Office 2001.



RESOLUTION
To run Microsoft Query in Excel 2001, you must install Data Access from the Value Pack for Microsoft Office 98, and install Microsoft Query from the Value Pack for Microsoft Office 2001.

For additional information about how to install Microsoft Query, click the article number below to view the article in the Microsoft Knowledge Base:

276503 XL2001: How to Install Microsoft Query in Office 2001



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
If you attempt to create a new database query in Microsoft Excel 2001, and Microsoft Query is not fully installed, Excel may take more than a minute before it displays the following error message:

Microsoft Excel could not start Microsoft Query because it is not installed. To install it, run the Value Pack Installer and select Microsoft Query. If Microsoft Query is already installed, run it standalone to force it to register with the system.

The last sentence erroneously suggests that if you run Microsoft Query as a stand-alone program, the problem will be resolved without any further action.

Additional query words: off2001kb mac XL2001KB msquery query install missing value pack OFF98 XL2001 Excel OFF2001 driver ODBC

Keywords: kbbug kberrmsg kbnofix KB270078

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.