Unknown error in Query Designer: 800401F9

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.
marydsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jdlambert1Commented:
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
marydsAuthor Commented:
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
jdlambert1Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marydsAuthor Commented:
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
HardeveldCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.