INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Member Feedback
"...This site is awesome!...Things I have been trying to figure out for weeks, I got the answer in hours!..."
Geography
Where in the world do Tek-Tips members come from?
|
Microsoft SQL Server: Programming FAQ
|
Enterprise Manager
|
Why can't I open a table in Enterprise Manager or Query Analyzer?
Posted: 10 Apr 03
|
When I try to open a table in Enterprise Manager I get error message "The query cannot be executed because some files are missing or not registered.
Query Designer cannot locate your query files and cannot run your query."
Before resorting to re-installing the product try re-registering the following dlls (they may be in different directories depending on your OS/Version)
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
To register the DLLs you use Regsvr32.exe
At a 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 Microsoft SQL Server: Programming FAQ Index
Back to Microsoft SQL Server: Programming Forum
My FAQ Archive
 Email This FAQ To A Friend |
|
 |
|
