PRB: Query Can Not Be Executed in SQL Enterprise Manager Query Designer on Windows XP (315868)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions), when used with:
    • the operating system: Microsoft Windows XP
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 "Workaround" 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
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbprb KB315868
©2003 Microsoft Corporation. All rights reserved.