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

View products that this article applies to.

This article was previously published under Q315868

Expand all | Collapse all

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.

Back to the top

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.

Back to the top

RESOLUTION

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

Back to the top

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

Back to the top