Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Unknown error in Query Designer: 800401F9

Posted on 2004-08-25
5
Medium Priority
?
341 Views
Last Modified: 2008-01-09
I am trying to retrieve data from my views. I can open the design view, but when I want to view the results of the query, I get:

Unknown error in Query Designer: 800401F9

This is urgent.
0
Comment
Question by:maryds
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 15

Expert Comment

by:jdlambert1
ID: 11896879
Here's a reference to your problem:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q273472

Here's a work-around: after designing, open the SQL pane, and copy the SQL. Then open Query Analyzer and paste the code, and execute from there...
0
 

Author Comment

by:maryds
ID: 11897240
I've already read the microsoft article. I uninstalled and reinstalled Enterprise Manager, and I still get the problem.

Tried your workaround and it doesn't recognize the tables I'm using -- must be doing something wrong.

Will try on another machine now.
0
 
LVL 15

Accepted Solution

by:
jdlambert1 earned 2000 total points
ID: 11897274
In QA, you need to make sure it's connected to the correct server and database. Also, if you have multiple copies of the database (such as two test databases, or a production database and a development database), then make sure the views exist on the database you're connected to. Can't think of anything else at the moment...
0
 

Author Comment

by:maryds
ID: 11897387
Works on another machine per the KB article. Will see if my SQL admin can apply the patch.

Your workaround works -- I was connecting to the wrong database.

Thanks!
0
 

Expert Comment

by:Hardeveld
ID: 12645070
I'm having the same problem, only in the Enterprise manager and returning rows from a table. Since the same error also occurs when trying to make a connection with Spotlight SQL, the work arround is not very helpfull. Is the a solution fi replacing the dll ? wich one ??
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question