Solved

Unknown error in Query Designer: 800401F9

Posted on 2004-08-25
5
329 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

760 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

19 Experts available now in Live!

Get 1:1 Help Now