Solved

Unknown error in Query Designer: 800401F9

Posted on 2004-08-25
5
331 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
  • 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 500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

896 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now