?
Solved

Unknown error in Query Designer: 800401F9

Posted on 2004-08-25
5
Medium Priority
?
339 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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

770 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