Microsoft KB Archive/315868

= PRB: Query Can Not Be Executed in SQL Enterprise Manager Query Designer on Windows XP =

Article ID: 315868

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition, when used with:
 * Microsoft Windows XP Professional

-



This article was previously published under Q315868



SYMPTOMS
After you install the SQL Server 2000 Client Tools on Windows XP, you may receive the following error message when you execute queries in the Query Designer through SQL Server Enterprise Manager (SEM):

The query cannot be executed because some files are either missing or not registered.



CAUSE
Some of the setup files are either missing or are not registered. Please refer to the &quot;Workaround&quot; section for a list of the files.



RESOLUTION
Run the setup of the SQL Server 2000 Client Tools again to make sure that the required files are registered.



WORKAROUND
If the reinstallation of the SQL Server 2000 Client Tools does not correct the problem, then re-register the following DLLs by using Regsvr32.exe, and then restart the computer: C:\Program files\Common Files\System\ADO\Msado15.dll C:\Program files\Common Files\System\Ole Db\Oledb32.dll C:\Program files\Common Files\System\Ole Db\Sqloledb.dll C:\WINNT\System32\Atl.dll Use Regsvr32.exe to register the preceding DLLs.

For example, at the command prompt type:

C:\>regsvr32 C:\Program Files\Common Files\System\ADO\Msado15.dll C:\>regsvr32 C:\Program Files\Common Files\System\Ole Db\Oledb32.dll C:\>regsvr32 C:\Program files\Common Files\System\Ole Db\Sqloledb.dll C:\>regsvr32 C:\WINNT\System32\Atl.dll

Keywords: kbprb KB315868

-

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

© Microsoft Corporation. All rights reserved.